Excel 2000 compatibility

[Ed Sowell]

The AddIn I developed in Excel 2007 now works on 2003 and 2002, but fails
when installed withe Excel 2000. The workbook will load just fine when I
strip all vestiges of VBA macros from it, but as soon as I try to enable the
AddIn it says, "Sorry, Excel has encountered an error and has to close.

Any idea what is causing this? For example, is this a known, basic
incompatibility issue? Or, perhaps a few techniques or functions that one
can avoid?

To be clear, the Addin was saved as an Excel97-2003 xla file under 2007.

I am trying to get my user to upgrade to a latter version, but he refuses to
consider Office 2007 because of what he has read about compatibility and
changes in the user interface. I've now asked him to consider Office 2003.
This brings me to another question, will Office 2003 Basic work, or would he
have to get the Pro version? What does Basic leave out?


Ed

 

[Jim Cone]

Do your add-in development in the oldest version that will use your program.
Then test it in all xl versions. However, that doesn't solve your current problem...

The following link is to a list of changes in xl2002 (from the prior version).
If you are using any of the features listed there, then xl2000 will have "problems".
http://msdn.microsoft.com/en-us/library/aa269686(office.10).aspx

For what its worth, you might have an easier time getting the xl2007 users
to upgrade back to xl2003.
'--
According to the back of my Excel 2003 box, the Office 2003 Professional Edition
contains the following that is Not included in the standard edition...
Business Contact Manager for Outlook
Publisher
Access
XML technology
IRM technology
--
Jim Cone
Portland, Oregon USA



The AddIn I developed in Excel 2007 now works on 2003 and 2002, but fails
when installed withe Excel 2000. The workbook will load just fine when I
strip all vestiges of VBA macros from it, but as soon as I try to enable the
AddIn it says, "Sorry, Excel has encountered an error and has to close.

Any idea what is causing this? For example, is this a known, basic
incompatibility issue? Or, perhaps a few techniques or functions that one
can avoid?

To be clear, the Addin was saved as an Excel97-2003 xla file under 2007.

I am trying to get my user to upgrade to a latter version, but he refuses to
consider Office 2007 because of what he has read about compatibility and
changes in the user interface. I've now asked him to consider Office 2003.
This brings me to another question, will Office 2003 Basic work, or would he
have to get the Pro version? What does Basic leave out?


Ed