LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default Backward compatibility for VB6 COM Excel Add-In

I'm developing a VB6 COM Add-in for Excel on a machine that current has
Office XP installed, which means that my VB6 project sets a reference
to the Excel 10.0 (2002/XP) object library.

I would like my add-in to be backward compatible with Excel 2000, which
uses the Excel 9.0 (2000) object library. In order to ensure this, as
far as I can tell I have 3 options:

1. Check the Object libraries for 2000 and XP looking for any
differences that might effect my code. Then cross my fingers and hope
for the best.

2. Buy and install Excel 2000 in order to get access to the older
library.

3. Obtain a copy of the Office 2000 SDK. Unfortunately, I can't seem
to locate this anywhere on MSDN.

Option 1 looks like my best bet. Has anyone tried this with success?
Any gotchas to watch out for.

Option 2 isn't appealing because of the cost and the configuration
headaches. If I had VPC or VMWare it would be less of an issue, but I
don't have either.

Option 3 would be optimal, but I don't know where to obtain a copy of
this SDK. Does anyone know if there are still copies available for
download?

Any advice would be greatly appreciated.

Thanks,

Nick

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot table in Excel 2007 & 2000 (backward compatibility problem) gordom Excel Discussion (Misc queries) 3 March 12th 09 10:23 PM
Excel 2007 Color Backward-Compatibility Issue JCooper Excel Discussion (Misc queries) 7 March 8th 08 07:59 PM
Excel 2007 backward compatibility re colors DON New Users to Excel 2 March 5th 07 07:49 PM
Worksheet name and Backward compatibility Rich Excel Discussion (Misc queries) 3 November 30th 04 06:10 PM
VBA - Macro backward compatibility from excel 2002 to excel 2000 Frank Krogh Excel Programming 3 April 2nd 04 07:08 PM


All times are GMT +1. The time now is 05:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"