Excel Automation - type compatibility

[vikrantca]

Hello,
Iam writing some code in VB 6.0 that will output the results of a
calculation to a spreasheet. I just need to create a new workbook and write
data to the first sheet in it.
Which type library/ object model version should I use while developing the
code, so that The code will compatible with versions of Excel from 2000
onwards ?
I tried compiling using Excel 2003, but the code gives an error "Library not
registered" when run on a computer with Excel 2000.

Thank you in advance.
vikrantca

 

[Dave Hart]

You need to develop your code with the earliest
version of Excel that you wish to run on.
In this case, Excel 2000.

Dave Hart

 

[Tom Winter]

Take a look at:

INFO: Writing Automation Clients for Multiple Office Versions
http://support.microsoft.com/default.aspx?scid=kb;EN-US;244167