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

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

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

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


"VB Script for Excel" wrote in message
oups.com...
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

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

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
--
Kevin Backmann


"VB Script for Excel" wrote:

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

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

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

Thnx

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

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.