Open Another Workbook and Call Macro

  • Thread starter Thread starter Bill Oertell
  • Start date Start date
B

Bill Oertell

Is it possible to open another workbook and call a subroutine in that workbook
from the workbook that opened it? I can think of a roundabout way of doing it,
but it would be nice if one could just do it.
 
Bill,

Once you have the workbook opened:

Application.Run "'FileName.xls'!MacroName"

or.................

Workbooks.Open Filename:="FileName.xls"
Application.Run "'FileName.xls'!MacroName"

John
 
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

Call routines of other workbooks? 1
Excel Protection 2
Calling subroutine defined in another workbook (autostart workbook) 5
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Run subroutines in other workbooks? 4
VBA Debug Issue 2
Run code from another workbook 7
Unwanted workbooks on startup 2

Back
Top