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

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

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

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

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