Execute Multiple Macros!

[JimmySwinger]

Greetings, all!

I have a virtual corneucopia of macros that I run daily. It takes up so much time and attention. I would love to create a macro that will launch multiple macros instead of me just executing one, waiting, execute another, wait... etc...

I have been trying to do this in visual basic (which comes up when I want to edit a macro) and I am definitely no programmer and unaware of the syntax used to launch a macro.

Can anybody help me?

Regards,

Jimmy

 

[Ricky Morris]

Try:

Sub Run_All_Macros()
Application.Run "'C:My DocumentsFilename.xls'!Macro1"
Application.Run "'C:My DocumentsFilename.xls'!Macro2"
Application.Run "'C:My DocumentsFilename.xls'!Macro3"
Application.Run "'C:My DocumentsFilename.xls'!Macro4"
End Sub

 

[AJ]

Or, if you are just adding the new run all macros subroutine to your existing workbook where all the other macros live as well, either of these will do it, e.g.

Sub option1()
macro1
macro2
macro3
End Sub

Sub option2()
Call macro1
Call macro2
Call macro3
End Sub

Either of the above run subroutines called macro1, macro2 and macro3.

AJ

 

[JimmySwinger]

I am truly grateful for the assistance you both have provided me. This will work wonderfully!!

Thanks a lot!