Addin for Excel 2000/97 (In Visual Basic)

  • Thread starter Thread starter Jason Sholar
  • Start date Start date
J

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
 
Jason Sholar said:
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?
Click to expand...

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
 
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
 
Back
Top