"Jason Sholar" wrote in message
m...
I have written an addin in Visual Basic for use in excel 2000 (which
is on my machine.) I used the new addin connection wizard that is
built into excel. The addin works fine on my system (excel 2000), but
I need to be able to also distribute the addin to users of excel 97.
When I tried to install the addin on one of their systems I could not
get it to work? How do you add the COM objects to excel 97?


You dont, Excel 97 doesnt support COM add-ins

The work around is to write a VBA bootstrap routine that sets
up the modified menus you need and maps them to VBA procedures

If you set a reference to the com addin from the VBA editor these
procedure can call the public methods in the com add-in provided
they are instantiated as global multi-use

Keith