Open Another Workbook and Call Macro
Bill,
Once you have the workbook opened:
Application.Run "'FileName.xls'!MacroName"
or.................
Workbooks.Open Filename:="FileName.xls"
Application.Run "'FileName.xls'!MacroName"
John
"Bill Oertell" wrote in message
...
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.
|