How can I call a macro in another workbook?

  • Thread starter Thread starter ned
  • Start date Start date
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
 
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,

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
 
Or even as an alternative create a reference to the other workbook and call
it like a native macro.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet_Change does not work 3
Call routines of other workbooks? 1
Run code from another workbook 7
Macro shortcuts are running macros in different open workbook 3
Calling subroutine defined in another workbook (autostart workbook) 5
Macro code for clicking on Command Button in another workbook 7
Can I call a macro from a specific book 2
run macro in another workbook - error 1004 7

Back
Top