Saving a Macro

  • Thread starter Thread starter SueN.Pools
  • Start date Start date
S

SueN.Pools

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!
 

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

Similar Threads

Lose macros before saving 4
security, enabling macros to enable a disabling saving function 12
macro to save file as 4
How to Unlock Excel Workbook protected by MACRO Password 6
Open and save blank workbook with Command Prompt 0
Autorun a macro on save 1
Copy & Paste from One Workbook to a Macroed Template Workbook 1
auto run a macro 1

Back
Top