Excel Interops for 2007 & earlier versions
 

I have an applicatioin written in VB.NET (Visual Studio 2008 Pro). It
currently reads and writes to Excel 2000, 2002 & 2003 via Interops.
I now need the application to support Excel 2007

When I attempt to use the application on a PC that has Excel 2007 installed,
errors occur in the application and it crashes.

I've been distributing Excel Interops with the application.

My questions a
What Interops should I be using?
Are they (the interops) backward compatible?
Should I expect to see a lot of code changes?

PS - I posted these questions on the Visual Studio Tools for Office forum
and was told to use this forum instead.

Excel Interops for 2007 & earlier versions
 

WAB

you'll see that Cindy pointed out why you were in the wrong forum but
actually answered your question...

There is an article written by andrew Whitechapel (see his blogs) as to how
to write addins that support 2003 and 2007.

if you use excel 2007 you should use version 12 interops.
interops for 2007 are not backward compatible for 2003...
Without knowing what your app does, I'd say you should expect to see code
changes, e.g the chart objects.

If you read changes about Excel 2007, you will understand what changes you
need to make, for instance Analysis Toolpak fucntions are now part of excel.



"WAB777" wrote:

I have an applicatioin written in VB.NET (Visual Studio 2008 Pro). It
currently reads and writes to Excel 2000, 2002 & 2003 via Interops.
I now need the application to support Excel 2007

When I attempt to use the application on a PC that has Excel 2007 installed,
errors occur in the application and it crashes.

I've been distributing Excel Interops with the application.

My questions a
What Interops should I be using?
Are they (the interops) backward compatible?
Should I expect to see a lot of code changes?

PS - I posted these questions on the Visual Studio Tools for Office forum
and was told to use this forum instead.