Creating an XML file with specific header

[ericbjr2]

The ultimate goal is to show a map with addresses listed on it from addresses in my database.

I have a query built to get the data into a readable format, but the problem is exporting to XML.

How do I export the data to an XML file with specific headers <rss...blah blah blah>
<channel>
<title>my channel</title>

(data goes here in the format I setup cheating, but making a table output the data in the format I need)

and at the end have
</channel>
</rss>

I would like to do this with vb if at all possible.

 

[PHV]

Have a look at the Application.ExportXML method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ericbjr2]

I have tried the Application.ExportXML method, but I don't know how to get the format to change. It always exports to the same format.