Convert a XML file into a Excel Sheet

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 […]