View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default 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.