Indirect reference to run macro in another workbook?
 

I've tested using the following syntax, and it does run my code just find
Application.Run "MyReallyLongComplicatedFileName.xla!TestMacro "

However, I want to make my code more flexible, and instead of hardcoding the
filename throughout my code every place I need to run some code from that
XLA, I tried setting it up as an indirect reference, e.g.,
Dim Codefile as AddIn
set CodeFile = "MyReallyLongComplicatedFileName.xla"

then in various parts of my code, call the macros using something more like:
Application.Run CodeFile!TestMacro or
Application.Run CodeFile & "!TestMacro"

but so far, I haven't figured out the syntax to make this type of indirect
code reference work.

Can anyone give me a hint?
Thanks!
Keith

Ignore this thread please
 

I just figured it out...
:-)
Keith

Indirect reference to run macro in another workbook?
 

Can you share your knowledge with the rest of us Keith?

I'm having a similar problem calling code from another workbook.

In one case it works and in the other it doesn't

my call line is as follows:

Application.Run (FinFile & "!AddShortCut")

The macro exists in both workbooks but in one case it gives me a
1004 error and says that it can't find the macro when it is clearly
there.

Any help would be appreciated.


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=550070