Addin for Excel 2000/97 (In Visual Basic)
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 |
Addin for Excel 2000/97 (In Visual Basic)
"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 |
Addin for Excel 2000/97 (In Visual Basic)
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 |
Addin for Excel 2000/97 (In Visual Basic)
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" 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? Any help would be greatly appreciated. Thanks, Jason |
All times are GMT +1. The time now is 07:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com