How to Represent an XML Document in VBA

[Ron Weller]

I have an access database and I need to add the ability to export orders into an xml file. I have been given an XSD file and a sample XML file to work with.

Now I could hard code the whole thing, but I was wondering if anyone has come up with a way to represent an xml document through some type of a class or class's.

If I could represent the Document in some type of structure that I could fill in the various elements and properties and then have it generate the XML text that would be saved to the appropriate file.

This way it would be eaiser to create new documents, or even create new versions of existing ones.

I am looking for any Ideas or suggestions on how to get started?

[Hack]

Are you compelled to use VBA for this project?

I had to do something similiar for one project. I do not know if this is the best way, but I dumped what I needed from my Access database table(s) into an excel spreadsheet, and then used the .NET code example I found here to convert it into XML