VCF To Excel Convereter – Convert contacts in VCARD to Excel with this app – Supports VCF file from Android, iPhone & Outlook & export VCF to Xls with ease. A Free Excel VBA Application Code. No installation required. Reads each contact detail from VCF file and export each to XLS format.
How to Add Sheets in Excel – VBA Create Worksheet – Dynamic Spreadsheet
Get Excel VBA Create Worksheet using Sheets.Add using the macro code from this page. Learn step by step methods to add spreadsheets dynamically.
Remove Junk Characters In Text File – Excel Trim Just Not Helping
Excel Trim Not Working – Remove Unwanted Characters Is Your Excel function TRIM not able to remove non-displayable characters? A Trim function will remove only the spaces at start & end of a text. Very less people know that there are other good functions available in Excel to remove special […]
Excel VBA AutoFilter Multiple Criteria in Array or List
Learn how to add Filter from Excel menu. Also get Excel VBA Autofilter multiple criteria macro code using array list. Learn MS Excel Advanced Filter, VBA code to Read Visible Data & Filter Criteria.
Anagram Maker – Word Combination Generator Source Code
Get free all possible Word combination generator from Letter. Anagram combination generator. This Excel app with code will generate anagrams of all combinations using letters input
Excel Convert – Number To Date – VBA Date Format
Use this tips to do Excel Date format formula customization. Also get Excel VBA date format tricks that can be used by Excel convert number to date.
Save Outlook Mail Attachment to Local Folder
GET Free Outlook VBA Code to Save all Email Attachments to a Folder in your Computer. Learn simple macro code to access Emails in a Outlook Mailbox or PST folder
Excel Vba For Each VBA If Else Switch Case
Get Code Snippets for Excel VBA IF Else, For Loop, Do While, Switch Case – Looping and Conditional statements. Use these IF Else, For Loop in Excel Macro
Convert Excel String To Date – VBA Date Format
Use this simple technique that converts Excel string to date using menu option & VBA code. Use VBA string to date conversion code in Excel automation.
Print Screen Automation – Take Screenshot, Save to File and Attach in Excel
Excel VBA Print Screen Automation – Get FREE VBA Macro to give 1) ALT TAB, 2) Press Print screen Key, 3) save Screenshot to Image file and 4) attach to Excel.