VB & Database, Accessing/Writing to Excel files

Accessing/Writing to Excel files

Author	Message
David Mar #1 / 3	Accessing/Writing to Excel files Quote: >Hi everyone, >I now use VB6 and I want to write a program to access and write to an Excel >97 spreadsheet. How are you doing that? Automating Excel? Quote: >I've done this successfully in VB5 but everytime my program finishes, the >spreadsheet crashes Excel when I try to load it. So if you are writing the file manually? What specs are you using? Quote: >Does anyone have any advice/experience? >Thanks, >Pete
Wed, 02 Oct 2002 03:00:00 GMT

Peter Iannett #2 / 3	Accessing/Writing to Excel files Quote: > >Hi everyone, > >I now use VB6 and I want to write a program to access and write to an Excel > >97 spreadsheet. > How are you doing that? Automating Excel? In VB5, you can use the OpenDatabase command specifying file format as "EXCEL 8.0", giving you access to the Excel file. However, doing this in VB6 seems to corrupt the file as I can't subsequently open up the file in Excel.
Fri, 04 Oct 2002 03:00:00 GMT

David Mar #3 / 3	Accessing/Writing to Excel files Sounds like a bug in the Excel provider. Did you try the KB? Quote: > > >Hi everyone, > > >I now use VB6 and I want to write a program to access and write to an > Excel > > >97 spreadsheet. > > How are you doing that? Automating Excel? > In VB5, you can use the OpenDatabase command specifying file format as > "EXCEL 8.0", giving you access to the Excel file. > However, doing this in VB6 seems to corrupt the file as I can't subsequently > open up the file in Excel.
Wed, 09 Oct 2002 03:00:00 GMT

Page 1 of 1

[ 3 post ]