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

Hello all!

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

Code:

---

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

FYI cross-post at
http://www.mrexcel.com/forum/excel-q...ddin-xlam.html

Quote:

---

Originally Posted by p45cal

FYI cross-post

---

Morning! (German time ;) )
Is this a problem? I also opened a thread at excelforum.com:
[edit]To be able to post links your post count must be 5 or greater. Your post count is 1 momentarily.[/edit]

I started to find out where I can get support for my problem. The german vba-communities are not really buzzing.

When I found a solution I can share it also in the other communities or is this not welcomed? Should I delete the postings?

Nice day!

The argument to Run is a string

Code:

---

Application.Run "filename.xlam!functionname"

---

Quote:

---

Originally Posted by exaveaIs this a problem? I also opened a thread at excelforum.com:
[edit

To be able to post links your post count must be 5 or greater. Your post count is 1 momentarily.[/edit]

I started to find out where I can get support for my problem. The german vba-communities are not really buzzing.

When I found a solution I can share it also in the other communities or is this not welcomed? Should I delete the postings?

---

http://www.vbaexpress.com/forum/faq...._new_faq_item3