Thread: Saving a Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] SueN.Pools@gmail.com is offline
external usenet poster
 
Posts: 8
Default 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!