Export 8 tables to seperate XML's Macro ?

[DJMegabit]

I am trying to set up a macro in Access to export 1 to 8 tables at once to xml docs in a destination folder.

If anyone know how to do this or can post a sample that would be great.

Thanks


---
I know how to right click export to xml fine, but I am looking for a way to automate it.

 

[lark_tilly]

I found some code and adapted it. It's not a macro but would replace it.
Open the attachment and look at the code in the module modXML.
This exports two tables, tblEmp and tblSales, to the desktop as XML files.
You can replace the table names with your own and the destination also.
To add more tables, copy the three lines starting with .open .save .close
and paste below the existing ones then replace the table name etc.
The code runs from the button on the form.

Hope this helps.