Knowledge Sharing

Hi All, As we all play around a lot with Excel in our Day to Day tasks, so automating that is a must thing. Below is a code to send the whole excel sheet via email on the click of a button, I know you can find this on various other sites as well, but I am also sharing the same as well. Below is the Macro to send a excel file as a attachment. Sub Send_email() Dim wb As Workbook Dim I As Long Set wb = ActiveWorkbook     If Val(Application.Version) >= 12 Then         If wb.FileFormat = 51 And wb.HasVBProject = True Then             MsgBox "There is VBA code in this xlsx file, there will be no VBA code in the file you send." & vbNewLine & _                    "Save the file first as xlsm and then try the macro again.", vbInformation             Exit Sub         End If  ...

DOS Attacks or Denial Of Services Attack have become very common amongst Hackers who use them as a path to fame and respect in the underground groups of the Internet. Denial of Service Attacks basically means denying valid Internet and Network users from using the services of the target network or server. It basically means, launching an attack, which will temporarily make the services, offered by the Network unusable by legitimate users. In others words one can describe a DOS attack, saying that a DOS attack is one in which you clog up so much memory on the target system that it cannot serve legitimate users. Or you send the target system data packets, which cannot be handled by it and thus causes it to either crash, reboot or more commonly deny services to legitimate users. DOS Attacks are of the following different types-: 1. Those that exploit vulnerabilities in the TCP/IP protocols suite. 2. Those that exploit vulnerabilities in the Ipv4 implementation. 3 There are also ...

Stopping by woods on a snowy evening   Whose woods these are I think I know, His house is in the village though. He will not see me stopping here, To watch his woods fill up with snow.   My little horse must think it queer, To stop without a farmhouse near, Between the woods and frozen lake, The darkest evening of the year.   He gives his harness bells a shake, To ask if there is some mistake. The only other sound's the sweep, Of easy wind and downy flake.   The woods are lovely, dark and deep, But I have promises to keep, And miles to go before I sleep, And miles to go before I sleep.

SugarCRM is the market-leading, commercial Open Source customer relationship management (CRM) application. SugarCRM’s Open Source architecture easily adapts to any business environment by offering a more flexible, cost-effective alternative than proprietary applications. It offers a complete CRM system for businesses of all sizes. For a small business SugarCRM can be a huge time and expense saver. It requires minimal technical knowledge to get it installed and the built in web administration console and backup system allow you to feel comfortable that it’s going to keep running. Core SugarCRM functionality includes sales automation, marketing campaigns, support cases, project mgmt, calendaring and more. Built in PHP, supports MySQL and SQL Server allows it that cool functionality LAMP system. We have tested it Windows XP/Vista/2k3 . Step 1: Installing XAMPP on Windows 1. Go to http://www.apachefriends.org/en/xampp-windows.html#641 and click "XAMPP Windows 1.7.1". Download...

How to Create a sub-panel and build relationships on the modules Oqc-Contract, oqc-Offering, oqc_products. Attention: Every time you need to make a change like this it's smart to backup the files to be modified and a backup the database. It must not be done when there are users on-line on the system. The module of OpenQuotesandContracts, can be downloaded at the site of sugarforge in projects, the modules were developed to work with mozzila. This manual will explainain how to create relationship with other modules, also create the sub-panels of these relationships. All customizations are not Upgrade-SAFE, or if made some customization the set up files, should be kept to verify the possibility of having integration with other future versions of sugarCRM. Many to many relationships on sugar CRM are made with some steps. - Define the link of relationship on the vardefs of both modules on the relationship - Create a metadata file with the fields of DB and definition of th...

Sugar Version: 5.1 Overview In many cases it is desirable to hide or show certain fields on a form based on the value of a field.   For example, if the account is a “partner” the form should show partnerish fields.   The easiest way to do this is to create panels with information specific to each record type and then hide or show the panels based on the record type. Step 1 – Rearrange the Edit and Detail Views Start with the edit view first.   From Studio, open the account edit view and create 2 panels. Name the first panel “CUSTOMER INFO” and the second panel “PARTNER INFO”.    The naming of these is very important because they will be used in the JavaScript code to hide these panels.   Drag some fields into both panels (See example below) Repeat the process for the detail view ensuring the panel names are the same. Creating a Custom Edit Handler Create a file called custom/modules/Accounts/views/view.edit.php.   This file is a custom edit view ...