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

"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.