I'm wondering if there is an easy Visual Basic program that can do this:
I have multiple spreadsheets (any where from 1 to 300 on any given day). For each of these spreadsheets I need to run the same Macro and then save the result in a specific folder. Is there a way to do this in a batch where I can do this for all spreadsheets at once?
1. Spreadsheet1.xls
2. Run Macro1
3. Save Spreadsheet1.xls in X filepath
1. Spreadsheet2.xls
2. Run Macro1
3. Save Spreadsheet2.xls in X Filepath
So on and so forth.
I'm not sure if this will play a part but Macro1 links to several other macros. The last line of Macro1 states "Application.Run "xxx".
I have multiple spreadsheets (any where from 1 to 300 on any given day). For each of these spreadsheets I need to run the same Macro and then save the result in a specific folder. Is there a way to do this in a batch where I can do this for all spreadsheets at once?
1. Spreadsheet1.xls
2. Run Macro1
3. Save Spreadsheet1.xls in X filepath
1. Spreadsheet2.xls
2. Run Macro1
3. Save Spreadsheet2.xls in X Filepath
So on and so forth.
I'm not sure if this will play a part but Macro1 links to several other macros. The last line of Macro1 states "Application.Run "xxx".