VBA Loads a XML file into a Excel Sheet An XML file is like a simple text file but structured in a predefined format using tags. Sometimes you need to view an XML file and do calculation on the data using Excel. The code below is used to open an […]
Excel VBA Code to Checks if File Exists in Path
December 27, 2021
Finding an exiting file and 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?
December 27, 2021
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.
December 27, 2021
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
December 27, 2021
Get VBA code to convert Excel range to a image file.
VBA – Find number of Dimensions in an Array
December 27, 2021
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
December 27, 2021
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?
December 27, 2021
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?
December 27, 2021
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
December 27, 2021
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.
