Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to create a macro that runs other macro in the same workbook
why would it be step0() ? or is that step1()?
Thnx |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
One macro runs then it auto runs another macro | Excel Discussion (Misc queries) | |||
Macro runs in source , but not when in Personal Macro Workbook | Excel Programming | |||
Excel Workbook automatically (by design) runs a macro | Excel Programming | |||
Excel Workbook automatically (by design) runs a macro | Excel Programming |