Indirect reference to run macro in another workbook?

  • Thread starter Thread starter KR
  • Start date Start date
K

KR

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run code from another workbook 7
Creating a macro that opens and runs multiple workbooks and macros 2
Solver with VBA 1
error when running macro from another workbook 8
Excel Excel 2010-Vlookup, Indirect, Workbook Reference 1
Recording Macro - Excel makes reference to a specific cell 4
Running macro in one workbook that refers to variable in another 3
Macro call, one workbook to another 7

Back
Top