URGENT : HOW TO USE Excel File with VB5.0 without having Excel installed

[StéphaneDebono]

Hi,


I would like to write codes in VB5.0 for modifying .xls files (Microsoft Excel 97). I would to read cells' value, to write things in several cells, ..., I mean doing in VB5.0 what I do when using Excel.


Is it possible without having Microsoft Excel 97 installed on my computer, to have a program independent of Microsoft Excel 97.


Please help me, this is URGENT.


Waiting for your reply.


Best regards.


Stephane.

[Chris Eastwood]

Hi


Sorry, no this isn't possible. Unless you want to find out the file format for

Excel spreadsheets and then handle that in your code.


You could code your program so that it uses an array to hold the cell values in memory, then you can write it out to a delimited file which Excel could read in.


Regards


Chris Eastwood


CodeGuru - The website for developers

http://www.codeguru.com/vb

[dada]

Hi,

I would like to write codes in VC5.0 for reading .xls files (Microsoft Excel 97). I would to read cells' value, to validate the cell value.


Please help me, this is URGENT.

Waiting for your reply.

Best regards.

dada