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

"Jason Sholar" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

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

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


"Jason Sholar" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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