Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
General VBA Question Help.
Hi everyone,
I have two seperate workbooks both containing different VBA codes to do something specific. i.e. Workbook "A" and Workbook "B" is it possible for me to start the macro in Workbook "A" and execute macro from Workbook "B"? if I have sub "A" from Workbook "A" and sub "B" from Workbook "B". How do I code it to execute Macro "B" in Workbook "A"? Sorry if I confused you! Thanks for your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
General VBA Question Help.
On Jun 17, 9:58*am, James8309 wrote:
Hi everyone, I have two seperate workbooks both containing different VBA codes to do something specific. i.e. Workbook "A" and Workbook "B" is it possible for me to start the macro in Workbook "A" and execute macro from Workbook "B"? if I have sub "A" from Workbook "A" and sub "B" from Workbook "B". How do I code it to execute Macro "B" in Workbook "A"? Sorry if I confused you! Thanks for your help you can do the following to call the b from a Sub call_other_macro() Application.Run "'B.xls'!macro_b" End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
General question | Excel Worksheet Functions | |||
General Question | Excel Discussion (Misc queries) | |||
General Question | Excel Discussion (Misc queries) | |||
General Question | Excel Worksheet Functions | |||
General question | Excel Programming |