how to create a macro that runs other macro in the same workbook

[VB Script for Excel]

I have a workbook that has 4 macros. Macros are named as "Step1",
"Step2", "Step3", "Step4".
How can I create a macro in the same file that would run Step1 to Step
4 in consecutive order?

Thanks
Dhaval K

 

[MD]

Sub step0()

Application.Run (MyWorkbook.xls!step2)
Application.Run (MyWorkbook.xls!step2)
Application.Run (MyWorkbook.xls!step3)
Application.Run (MyWorkbook.xls!step4)

End Sub

Sub step1()

End Sub

Sub step2()

End Sub

and so on

 

[Guest]

Open the VB editor and create a macro named whatever, and then just list the
macro names, one per line, in the order you want them to run

Sub RunEmAll()

Step1
Step2
Step3
Step4

end sub

 

[VB Script for Excel]

why would it be step0() ? or is that step1()?

Thnx

 

[VB Script for Excel]

Also, instead of putting the name of the workbook (MyWorkbook.xls), can
i put a name that refers to this workbook? This is because if i change
the filename tomrrow, the macro wouldn't work.

If i use this:
Set z = activeworkbook
Application.Run (z!step1)
and so on
End Sub

This doesn't work. It says cannot find file z.

Thanks again.