Running macro in another workbook
 

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

Running macro in another workbook
 

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
--
Gary''s Student - gsnu200717


"Barb Reinhardt" wrote:

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