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

Become an Σxpert at Σxcel.com

 


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

  •