Export data + backup

[Chrisopia]

I have created a tool to export data into an xml file.

This xml file is then loaded in flash for various tools.

I was wandering if there was a way to automatically rename the xml (say tag on date and time to the end of the file name) before exporting the xml file - in one click of the button

Hope you can help!

 

[boblarson]

What code are you using to create the XML file?

 

[Chrisopia]

Well at the moment, I am using the simple code:

Private Sub XML_Click()
DoCmd.RunSavedImportExport (Yelloows)
End Sub

It runs the saved export, and asks if I want to replace the existing XML file.

 

[Insane_ai]

Here is a reference from MSDN regarding XML exports. Using this method should allow you to provide custom naming of your files by programatically creating a string.
I do this with daily report files with a date stamp added to the name of the report. I realize it's not utilizing what you already have but it may prove to be worth it.


http://msdn.microsoft.com/en-us/library/aa221224(v=office.11).aspx