Addin for Excel 2000/97 (In Visual Basic)

[Jason Sholar]

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?

Any help would be greatly appreciated.

Thanks,
Jason

 

[Keith Willshaw]

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

 

[Jan Karel Pieterse]

Hi Jason,

How do you add the COM objects to excel 97?

AFAIK you don't, they were introduced with Office 2000.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Chip Pearson]

Jason,

COM Addins are not supported in Office 97. They were introduced
in Office 2000.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com