View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wojtek wojtek is offline
external usenet poster
 
Posts: 3
Default Problem with calling addin macros in ExcelXP

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