Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default 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.

  #4   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 594
Default 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.



Reply
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
Multiple Excel versions. Naveen Mukkelli Excel Discussion (Misc queries) 0 May 16th 06 12:55 AM
Multiple versions of excel ... John Keith[_2_] Excel Programming 3 January 9th 06 04:55 PM
VBA, SQL, and multiple versions of Excel Terry Detrie[_2_] Excel Programming 2 December 2nd 05 12:18 AM
VB6 COM Add-In for multiple Excel and Word versions Yossi[_2_] Excel Programming 1 November 6th 04 08:11 PM
VB6 COM Add-In for multiple Excel and Word versions Yossi[_3_] Excel Programming 0 November 3rd 04 08:09 PM


All times are GMT +1. The time now is 02:12 AM.

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

About Us

"It's about Microsoft Excel"