Did you know that you can automate every version of Excel if you reference
the correct type library? If you need compatability with Excel 97 and
higher, just reference the Excel 8.0 type libraries. (You'll need to have
Excel 97 installed on your development machine.) The later versions of
Excel are backwards compatabile to earlier type libraries. Of course, your
users will need to have some version of Excel installed for this to work.
Another option is to try to write your data directly to the Excel binary
file format. Here's some information that may help:
INFO: Support for the Microsoft Office Binary File Formats
http://support.microsoft.com/default...NoWebContent=1
FILE: How to Create a BIFF5 File
http://support.microsoft.com/default...NoWebContent=1
Microsoft Excel 97 Developer's Kit
http://msdn.microsoft.com/library/de...html/SFA86.asp
"Chris" <(E-Mail Removed)> wrote in message
news:1daf01c38826$11032760$(E-Mail Removed)...
> Ok, here is my problem:
>
> We need to export a multi-worksheet spreadsheet in Excel
> that is compatible back to Excel 97. We can not use 3rd
> party tools or the automation since it relies on the user
> having a particular version of Excel installed.
>
> Does anyone know a solution that will allow us to export
> data to excel 97 spreadsheet and put data in a number of
> tabs(worksheets) using Visual Basic.NET and nothing 3rd
> party or dependent on Office being installed. CSV was not
> a solution since it does not support mutliple worksheets.
>
> Please help.
Similar Threads
