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
September 26, 2022
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.
Excel To VCF Converter – 81,000+ Downloaded – Excel To Vcard App
Excel to VCF converter: Get Excel to VCard converter built using VBA. Create Vcard file using contact in Excel. VCF is supported in Android, iPhone & Outlook. VCF file generated can be imported to Android, iPhone & Outlook contacts
Excel VBA html Table import – Export Web Table to Worksheet
Export HTML table to Excel VBA. This code can also be used a Best Data Mining Tool. When Web query did not work, Use the option explained in this article to import Web page Table with just Excel VBA and process the Tags as explained in this quick reference Tutorial.
