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
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?
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.
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 – Find number of Dimensions in an Array
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
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?
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?
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
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.