Problem with calling addin macros in ExcelXP

[wojtek]

Hi,
Has anyone experienced the following problem?:

My workbook "mywkb.xls" has a reference to an addin "myaddin.xla".
The VBA code in Autpen event contains the following call:

Call myaddin.macro1(arg1, arg2)

This runs perfectly on Win2000/Excel2000.
On WinXP/ExcelXP VBA editor shows up and I'm getting the following error:

"Variable not defined" and myaddin keyword is selected.

It looks like the "dot" operator doesn't work on XP (on 2000 I'd get full
list of macros when typing "myaddin.")
I have to figure out how to make the "myaddin." working due to the backward
compatibility requests.

Please advise.

Thanks,
Wojtek

 

[Damo]

You could try saving the addin as a .xls file and change the properties in
VBA of the workbook to Add-In=True, dump the .xls file in the XLSTART
directory and call the macro as a normal macro.

 

[wojtek]

The problem is that the users already have previously created workbooks with
myaddin.macro() code in the ThisWorkbook object.
So, I have to find a way to make this working.
Could it be some security settings (not general ones but new keys in
registry)?