| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Batch Processing macro for excel
I am developing a report in excel and it pulls from multiple excel sheets. I
have developed a macro to run it, but I'd like to develop a macro to run them all at once (actually re-running my macro) and saving them in between. Any thoughts. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Batch Processing macro for excel
In addition, can I get the files to save based on a account name in a column
in the excel sheet. ie I have a column called account and I'd like that to be the name of the excel sheet. "Brian" wrote: I am developing a report in excel and it pulls from multiple excel sheets. I have developed a macro to run it, but I'd like to develop a macro to run them all at once (actually re-running my macro) and saving them in between. Any thoughts. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Batch Processing macro for excel
It seems to me that if you already have a macro to do one sheet, then you
have a macro to do all the sheets. Simply put the sheets in an array and use the array to call the sheets in turn. All you have to do then is make sure there is a save routine in the loop. "Brian" wrote: I am developing a report in excel and it pulls from multiple excel sheets. I have developed a macro to run it, but I'd like to develop a macro to run them all at once (actually re-running my macro) and saving them in between. Any thoughts. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Batch Processing macro for excel
How do I go about it if there multiple excel files?
"JLGWhiz" wrote: It seems to me that if you already have a macro to do one sheet, then you have a macro to do all the sheets. Simply put the sheets in an array and use the array to call the sheets in turn. All you have to do then is make sure there is a save routine in the loop. "Brian" wrote: I am developing a report in excel and it pulls from multiple excel sheets. I have developed a macro to run it, but I'd like to develop a macro to run them all at once (actually re-running my macro) and saving them in between. Any thoughts. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro for processing one excel file and saving it to other | Excel Programming | |||
| Help finding a "batch processing" technique for a userform??? | Excel Programming | |||
| Open Batch File For Processing | Excel Programming | |||
| Run Excel Macro in a Batch File | Excel Programming | |||
| how to run recorded macro without showing processing excel sheets | Excel Programming | |||
Linear Mode
