How can I call a macro in another workbook?

N

ned

Is it possible for one workbook to call macros that are in another workbook.
Not add-ins, regular workbooks.

Thanks (again)


--
Regards,

Stephen

____________________________________________________________________________
____
S. Fitzgerald, P.Eng, MASc.
Practical Composites, Inc.
Halifax, NS
Canada
 
B

Bob Phillips

Stephen,

Look up Application.Run in help.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
C

Chip Pearson

Ned,

Assuming the workbook containing the macro to run is open, you
can use Application.Run to do this. E.g.,

Application.Run "BookName.xls!MacroName"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
T

Tom Ogilvy

Or even as an alternative create a reference to the other workbook and call
it like a native macro.
 
Top