Thread
:
Run excel macro on one xls from another xls
View Single Post
#
2
Posted to microsoft.public.excel.programming
Mike Fogleman
external usenet poster
Posts: 1,092
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.
Reply With Quote
Mike Fogleman
View Public Profile
Find all posts by Mike Fogleman