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
 
Back
Top