Services4People

How to Create Index in Excel sheet by using VBA Code Open a New Excel sheet Click on Main tab ( Click on blank area) Click on Customize ribbon. After opening customize ribbon. Click on Add-ins tab Click on Manage [Excel Add-in)  Go Tab Browse File ( Create Index file) Click on ok button. Click on File and click on option  Click on Customize ribbon Click on Macro Click on Main Tab Select Home Tab Click on New Group Do Rename of New Group Select VBA Code ( Ex. Create Index.Xlam..) Select created New Group Click on Add button Click on New Tab Do rename of New Tab Select any Icon Click on OK After completion of above process, a new icon will be created under home tab Click on new icon ( Create Index) Index sheet will be created. Thank you

 How to Export Excel file to PDF and Save in Folder by using VBA Button  Open a new excel file Click on developer tab Click on visual basic tab Click on Insert tab Click on Module tab Paste VBA Code Replace Folder path  Save this file in Excel Macro enabled work book format. OR Save it in Excel Add-ins format. Paste that saved file in below folder path (in C drive) Do right Click on any free white space. A new option list will be Opened Click on Customize ribbon.  Select Macro Select Main Tab Select Home Tab Click on New Group Do Rename created New Group Select New Group Select VBA Code ( Ex. SaveActiveSheetAsPDF...) Click on Add button. Click on New TAB under new group Do Rename of New Tab. Select any Icon for new Tab and click on ok A New Button with VBA code will be created under home tab in all excel sheet. Select print range by using page set-up under page Layout tab. Click on button & file will be exported in folder.     Exported PDF file will be placed in folder. Sample file

How to save mail Attachment in a Folder by using VBA button  If you want to save the active email's attachments while it is open, you can use the following VBA code: Please replace " C:\Your\Defined\Folder\Path \" with the path where you want to save the attachments. You can run this code from the Developer tab in Outlook after you've created a new module in the VBA editor and pasted the code into it. This code is designed to work on the currently active email and save its attachments to the specified folder. Select any incoming mail Click on Developer Tab Click on Visual Basic tab. Create a New Folder. Copy folder path Click on Insert Tab Click on Module Tab Paste VBA Code (  Download VBA Code  ) After Paste VBA Code replace folder path  Click on close and return to microsoft outlook. Click on File tab Click on Customize Ribbon tab Select Macro Select Main Tab Select Massage tab Click on New Group Do rename of New Group  Select New Group again Select VBA Code (Ex. Pr