View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default Run excel macro on one xls from another xls

Application.Run ("A.xls'!Macro1")

A.xls needs to be open first.
Mike F
"Kishore Shenoi" <Kishore wrote in message
...
I need to call a macro Macro1 written in A.xls from another macro Macro2
written in b.xls.

The file name "a.xls" is actually stored in column A on of b.xls, thus is
in
a variable. Macro name Macro1 is defined and static.