Run a Marco in another workbook

helpexcel

Well-known Member
Joined
Oct 21, 2009
Messages
541
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!
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

JoeMo

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

Watch MrExcel Video

Forum statistics

Threads
1,090,549
Messages
5,415,219
Members
403,572
Latest member
ballardgirl

This Week's Hot Topics

Top