How can I call a macro in another workbook?
 

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

How can I call a macro in another workbook?
 

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)

"ned" <pcompNOSPAMatCanada.com wrote in message
...
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

How can I call a macro in another workbook?
 

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


"ned" <pcompNOSPAMatCanada.com wrote in message
...
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

How can I call a macro in another workbook?
 

Thanks, I should have found that myself.

Stephen

"ned" <pcompNOSPAMatCanada.com wrote in message
...
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

How can I call a macro in another workbook?
 

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

--
Regards,
Tom Ogivly


"Bob Phillips" wrote in message
...
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)

"ned" <pcompNOSPAMatCanada.com wrote in message
...
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