Saving a Macro
 

I have created a macro that opens all files in a folder and runs my
macro. I am having an issue atomatically saving this.

My macro opens the file, runs my macro which in turn runs another
macro that creates an XML file from the new workbook.

I need to save both the new workbook, and the XML. I can't figure out
how to automatically save these... it keeps prompting me for a file
name. Any ideas with this? Thanks!

Saving a Macro
 

Show what you have now

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ps.com...
I have created a macro that opens all files in a folder and runs my
macro. I am having an issue atomatically saving this.

My macro opens the file, runs my macro which in turn runs another
macro that creates an XML file from the new workbook.

I need to save both the new workbook, and the XML. I can't figure out
how to automatically save these... it keeps prompting me for a file
name. Any ideas with this? Thanks!