Run a Marco in another workbook

helpexcel

Well-known Member
Hi - I have workbook1 that i'm running macros in. One of those macros brings over data from workbook 2. Workbook2 has it's own macros. Is it possible to put code into workbook1 that will run a macro in workbook2 before bringing over the data? Meaning workbook2 has a macro called "Update" can i have workbook1 tell workbook2 to run "Update"?

Thanks!
 

JoeMo

MrExcel MVP
Assuming workbook 2 is open and is named "workbook2.xlsm", try this line in WB1's macro:
Code:
Application.Run "'workbook2.xlsm'!Update"
 

Some videos you may like

This Week's Hot Topics

Top