Run a series of Macros from within a macro 4

[sterlecki]

I have several excel macros stored in my Personal.xls workbook. I would like to create a master macro or some code that would take macro A, B, C, D...etc. and sequentially execute them. I've done this in access but can't seem to find the equivalent statements for Excel.

 

[ETID]

it used to be something like...

application.run macro:="macro_name"

 

[mrmovie]

Sub globalMarcoStart()

Call module1.Macro1()
Call module2.Macro2()

End Sub

'or am i silly and macros are things other than Sub's or functions?

 

[xlbo]

nope - and if they are in the same module, it is even easier than that eg

Sub First_Sub()
msgbox "Running 1st sub"
End sub

Sub Second_Sub(passVar as integer)
msgbox "Hello Number " & passVar
End sub

Sub Run_All()
First_Sub
Second_Sub(1)
End Sub

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[sterlecki]

Thanks all.

I also got this to work using

Sub MainMacro ()
Call Macro1
Call Macro2

End Sub

Same as mrmovie shows. Thanks again

 

[xlbo]

You only need the Call syntax if you want to force the use of named arguments...(ie the byRef as integer type things)

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[mrmovie]

i didnt realise there was actually a point to the Call statement. i tend to use it just so i can see whats going on better, cheers for the tips