ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Manipulating Multiple Versions of Excel, c# (https://www.excelbanter.com/excel-programming/411471-manipulating-multiple-versions-excel-c.html)

Matthew

Manipulating Multiple Versions of Excel, c#
 
I just finished my project with Studio 2008, Excel 2007, and C#. I read a csv
file, parse the data, and enter it into a formatted excel spreadsheet.

I just learned that it's going to need to be functional for all versions of
excel after 97, however.

I Wrote it specifically for 2007.

How would any of you recommend doing this?

I have the code written, but I doubt it's going to work on previous versions..

Right now i'm using the Excel 12.0 object library. Is there a library that
will handle multiple versions?

The reason is that my client base may have anywhere from excel 97 to 2007
installed, and there is a wide group.

Any help would be greatly appreciated.

CLR

Manipulating Multiple Versions of Excel, c#
 
I have a similar situation, except I write small programs for xl97 to Xp
versions. I have less toruble if I just write everything in 97.......so far
it all runs on the later versions....

Vaya con Dios,
Chuck, CABGx3

"Matthew" wrote:

I just finished my project with Studio 2008, Excel 2007, and C#. I read a csv
file, parse the data, and enter it into a formatted excel spreadsheet.

I just learned that it's going to need to be functional for all versions of
excel after 97, however.

I Wrote it specifically for 2007.

How would any of you recommend doing this?

I have the code written, but I doubt it's going to work on previous versions..

Right now i'm using the Excel 12.0 object library. Is there a library that
will handle multiple versions?

The reason is that my client base may have anywhere from excel 97 to 2007
installed, and there is a wide group.

Any help would be greatly appreciated.


Matthew

Manipulating Multiple Versions of Excel, c#
 
Ah thanks, that's a good idea. It never crossed my mind to do it all in xl97,
as it's always forwards-compatible.

I'm not using any new features of 07, so that should work.

If you don't mind my asking, how do I go about getting the api's for 97? I
assume i'm going to have to install Office 1997 and then find the correct
api's..

Is there a com object specifically for 97?

"CLR" wrote:

I have a similar situation, except I write small programs for xl97 to Xp
versions. I have less toruble if I just write everything in 97.......so far
it all runs on the later versions....

Vaya con Dios,
Chuck, CABGx3

"Matthew" wrote:

I just finished my project with Studio 2008, Excel 2007, and C#. I read a csv
file, parse the data, and enter it into a formatted excel spreadsheet.

I just learned that it's going to need to be functional for all versions of
excel after 97, however.

I Wrote it specifically for 2007.

How would any of you recommend doing this?

I have the code written, but I doubt it's going to work on previous versions..

Right now i'm using the Excel 12.0 object library. Is there a library that
will handle multiple versions?

The reason is that my client base may have anywhere from excel 97 to 2007
installed, and there is a wide group.

Any help would be greatly appreciated.


CLR

Manipulating Multiple Versions of Excel, c#
 
I'm afraid you're beyond my skill level with those questions
Matthew.......perhaps someone else can help with them. I just have the
three versions of Excel installed on my computer at work, and write all my
code in 97.

Vaya con Dios,
Chuck, CABGx3


"Matthew" wrote in message
...
Ah thanks, that's a good idea. It never crossed my mind to do it all in

xl97,
as it's always forwards-compatible.

I'm not using any new features of 07, so that should work.

If you don't mind my asking, how do I go about getting the api's for 97? I
assume i'm going to have to install Office 1997 and then find the correct
api's..

Is there a com object specifically for 97?

"CLR" wrote:

I have a similar situation, except I write small programs for xl97 to Xp
versions. I have less toruble if I just write everything in 97.......so

far
it all runs on the later versions....

Vaya con Dios,
Chuck, CABGx3

"Matthew" wrote:

I just finished my project with Studio 2008, Excel 2007, and C#. I

read a csv
file, parse the data, and enter it into a formatted excel spreadsheet.

I just learned that it's going to need to be functional for all

versions of
excel after 97, however.

I Wrote it specifically for 2007.

How would any of you recommend doing this?

I have the code written, but I doubt it's going to work on previous

versions..

Right now i'm using the Excel 12.0 object library. Is there a library

that
will handle multiple versions?

The reason is that my client base may have anywhere from excel 97 to

2007
installed, and there is a wide group.

Any help would be greatly appreciated.





All times are GMT +1. The time now is 10:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com