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.

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.

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.

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.