VB6 to Excel and back???

[Nevidea]

What is the best way to read/write data back and forth from Visual Basic 6 and Excel? I know how to make Visual Basic create excel spreadsheets with the information I need in the correct spots. Shown below:

Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Add
    Set oSheet = oBook.Worksheets(1)
    oSheet.Range("A1").Value = LastName.Text & "_" & FirstName.Text & "_" & Last4.Text
    oSheet.Range("B1").Value = Phase.Text
    oSheet.Range("C1").Value = DS.Text
    oSheet.Range("D1").Value = RoomNumber.Text
    oSheet.Range("E1").Value = "Destination"
    oSheet.Range("F1").Value = "LB1"
    oSheet.Range("G1").Value = "LB2"
    oSheet.Range("H1").Value = "DTOUT"
    oSheet.Range("I1").Value = "DTIN"

oBook.SaveAs "C:\Documents and Settings\Brooks\Desktop\Duh\" & LastName.Text & "_" & FirstName.Text & ".xlw"
oExcel.Quit

Now, my question is, how can I get Visual Basic to read and modify this information in the ".xlw" format? Or would it be easier to use ".csv" files? I was going to try to the csv files, but I can't figure out how to get Visual Basic 6 to create the csv files.

Does anyone have any suggestions, sample code or opinions to share?

[RobDog888]

If you are using the Excel Object Model already then why go with csv? The EOM will let you read/write to any cell. Just use the Cells collection instead of the Range object and remember to destroy your sheet object variable as well as close and destroy your book variable as it could keep a reference to Excel which will keep it running behind the scenes.

See my Office FAQ (link in sig) for other tips.