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 |
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 |
All times are GMT +1. The time now is 11:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com