Finding an existing file & its path using Excel VBA When writing Excel VBA code that works with external files like XML or JSON, it is important that you have controls in your code to check it the file exist. If your macro (VBA program) doesn’t find a file when […]
How to remove Signature from Outlook Email using VBA code?
November 17, 2022
Get the Outlook vba code to remove the signature from a email that was autoamtically created within the macro. It is usefull when you add custom signature.
VBA To Find Last Row or Column in a Excel Wroksheet.
November 17, 2022
Get VBA code to find the last row or column in a Excel wroksheet. Pass sheetname as parameter and get last row/column returned.
VBA Convert Excel range to JPG Image
November 17, 2022
Get VBA code to convert Excel range to a image file.
VBA – Find number of Dimensions in an Array
November 17, 2022
How to find the dimensions in an array using Excel vba code? Here is the code to cound the array dimensions using the ubound function – tricky one.
VBA Combo box Add Items – from Excel Range or Array
November 17, 2022
VBA code to add items to Combobox Userform. Different methods to add combobox dropdown items present in a userform using the VBA code.
How to Add Leading Zeroes in Excel – for Numbers?
November 17, 2022
Learn how to add leading zeroes in Excel for numbers in cell. You can add zeroes to the display formats or to values with formula and few simple methods.
How to run VBA Macro Daily without opening Excel file autiomtically?
November 17, 2022
Steps to schedule a macro to run daily automatically with sample code & setup scripts. Try this and test run by scheduling any VBA macro run automatically
Run Macro from Another Workbook – Excel VBA
November 17, 2022
Get code snippet to run macro from another workbook using Excel VBA command. This command works like a remote control to run VBA code in remote file.
Export VCF to Excel – Converter Online – Using Google Account
November 17, 2022
Export VCF to Excel file using Google. Load Vcard file to Excel and convert them to a CSV file. This way it is easy to import the contacts to xls file.
