Thanks for the pointers. I dont know, whether this is the best approach to the problem or not, but here is how I got it to work. I referenced the Microsoft XML, v2. Excel VBA create new workbook code is used to create, copy data save with a name. Access newly created workbook with object. Excel file. You can convert your Excel file to an XML data file, or vice versa. This enables you to exchange data between different applications. First, turn on the Developer tab. Whats the syntax for saving an Excel workbook file so it saves over the existing same filename without prompting you Cant seem to find it. Read Xml File From Vba To Vsto' title='Read Xml File From Vba To Vsto' />Hi Experts I have an XML file which I am using to store settings with which I wish to populate a user form in Word VBA. I have previously used. How to work with XML files in VBA VBA XML. Learn how to use XPath and how to traverse the XML Dom with the MSXML2. Solidworks Mold Tools. DOMDocument object. Open Files In VBA With These 2 Macros. The cookie settings on this website are set to allow cookies to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click Accept below then you are consenting to this.