Have 2 Macros run in a specific order...Can This Be Done

[Guest]

Right now I have a macro named Auto_open and as you know as soon as excel is
opened it runs the macro. This macro copies 100 Excel spreadsheets from one
location on the network to a different location. Works Fine.

I then have another macro that takes all those 100 spreadsheets and combines
them into 1 spreasheet. Works Fine.

Is there a way that I can have the Auto_open macro run 1st just like it
does, and then as soon as it finishes, have the other Macro to merge the
spreadsheets run without the user having to acutally click on Run Macro?

Thanks;
The Dawg

 

[Guest]

I keep getting a compile error:
Only comments may appear after End Sub, End Function, or End Property

 

[Chip Pearson]

This message indicates that you are placing the call to
SecondMacro after the End Sub statement. Don't do that. Put it
before the End Sub line.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message