Hi,
Has anyone experienced the following problem?:

My workbook "mywkb.xls" has a reference to an addin "myaddin.xla".
The VBA code in Auto_Open 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

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" wrote:

Hi,
Has anyone experienced the following problem?:

My workbook "mywkb.xls" has a reference to an addin "myaddin.xla".
The VBA code in Auto_Open 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

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)?

"Damo" wrote:

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" wrote:

Hi,
Has anyone experienced the following problem?:

My workbook "mywkb.xls" has a reference to an addin "myaddin.xla".
The VBA code in Auto_Open 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