Use Application.Run:
Code:
--------------------
Application.Run "'Book1.xls'!MyMacro"
--------------------
Michelle;723207 Wrote:
I have a number of workbooks open all with a macro called 'MyMacro' in
them
2 Questions:
1. When there are a few open, how can I run the macro from a particular
book
(I want something like: Call Workbooks("Book1.xls").MyMacro)
2. Also... How can I run the MyMacro macro from the ActiveWorkbook?
Thanks
M
--
aflatoon
Regards,
A.
------------------------------------------------------------------------
aflatoon's Profile:
http://www.thecodecage.com/forumz/member.php?u=1501
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=202552
http://www.thecodecage.com/forumz