Exporting data to Excel 97

[ChrisCote]

I am a college student using VB 6.0 and I am trying to send data from my program to an Excel 97 worksheet, but I keep getting a "Couldn't find installable ISAM" error message. When I installed VB6, I made sure that I included all of the ISAMs in the installation. Any ideas?

[Lloyd]

I think the ISAM for Excel 97 is <Excel 8.0> and then the database path behind it.

EX.) "Excel 8.0;DATABASE=C:\temp\rates.xls"

E-mail me if you have any problems, I am working on something close to this.

Lloyd

[Lloyd]

I think the ISAM for Excel 97 is <Excel 8.0> and then the database path behind it.

EX.) "Excel 8.0;DATABASE=C:\temp\rates.xls"

E-mail me if you have any problems, I am working on something close to this.

Lloyd

[ChrisCote]

It's still not working. I don't know what's going on!!

[ChrisG]

I have the same problem, but I need to export to Excel 4.0. I think this should work with 97 too, but maybe not.

I have no idea how to export (or import) to excel formats, but it does support ascii files. You won't be able to do anything with fonts, or graphs. Basicaly, just the stuff you can do in notepad, plus formulas. It goes like this:

To save data in cell "E?" you would put 4 (E = 5 - 1) tabs on the line, and enter a value or a formula. To enter data in to cell "?5" you would put 4 (5 = 5 - 1) enters, and then the data. So to put "=Date()" in cell "E5" the file would look like "{ENTER}{ENTER}{ENTER}{ENTER}{TAB}{TAB}{TAB}{TAB}=DATE()".
You can even name the file with an .xls extention.