By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 374 - XML File format

I used VBA to generate XML output.

What is XML?

What did the code do?

Anything Special that it did?

A regulating authority required the output of a report in an XML format.

Steps:

Run query to create an Excel output for particular Legal Entity

Read the Excel file and formats it in an XML format

Open an Excel Template to go to regulator

Update the Template with the data

Save the file

Attach footnotes

Save the file and send in email to user