Create XML file with VBA?

[Anonymous]

Hi guys,

Does anyone have a snippet of code to create an XML file and add content with VBA?

I've done some research, and it seems I may need to download a 3rd party reference to add to the code, but I'm don't think it needs to be that complicated at all... I'd be quite happy to create a text file, and save it as a .xml file...

Any help would be appreciated.

Regards

[Anonymous]

Surely someone out there must be able to help out on this one...

[nmunro]

Add a reference to Microsoft XML X.0 (can be many versions on machine). Create a DOMDocument object, which will give you tools to create and work with xml data.