How do I automate a daily export of XML data to the same file?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know of a method to automatically export XML data an external
file? I need the file to receive updates periodically, without being required
to confirm overwrite of file.

Thanks,
Kevin
 
Hi Kevin,

You can use the VBA Kill statement to delete the existing file before
exporting the new one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top