Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
Visual BASIC in Excel | Excel Worksheet Functions | |||
Excel 2000/Visual Basic -- I need to learn... | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
excel/visual basic | Excel Programming |