Call a function in another Excel 2010 AddIn (.xlam)

[exaveal]

Hello all!

I try to call a function/procedur in an Excel2010-AddIn (.xlam file) from another Excel2010-AddIn (.xlam file):

Application.Run (filename.xlam!functionname)

Both AddIn-files are in the same directory (the default AddIn directory).
This call causes the error message "runtime error 91: object variable or with block variable not set".

This problems came up with providing an existing Excel2003-AddIn for Excel 2010.
The same code runs in following cases:
1. call a function in an Excel2003-AddIn (.xla) from another Excel2003-AddIn (.xla)
2. call a function in an Excel2003-AddIn (.xla) from a Excel2010-AddIn (.xlam)

Does anybody knows this problem and has perhaps a solution for this?


Thanks a lot, I tried all I could do.
Greetings, exaveal

 

[Jon von der Heyden]

Hello and welcome to the board

Cross-post here: Call a function in another Excel 2010 AddIn (.xlam) - VBA Express Forum

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #10 here along with the explanation: http://www.mrexcel.com/forum/showthread.php?t=99490). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

As a new member here I encourage you to read the rules in full.