Running macro in another workbook

B

Barb Reinhardt

I'm writing a macro that would a be a "one time use" for many people, so
don't want to have to save it in a workbook they use that is already fairly
large. I need to know how to call a macro in a workbook that I'm referring
to as aWB from my code.

Thanks,
Barb Reinhardt
 
G

Gary''s Student

Let's say we have macro named barb in workbook aWB. Just include:

Application.Run "aWB.xls!barb"

to activate the macro from a different workbook
 
Top