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