I'm lost using VB6 - not at all used to it and having trouble finding a simple way to open spreadshhet and write data to it.

No doubt simple, but I've only managed to access data in an existing sheet.

Preferably, I'd like a pointer to an example that creates a new excel file and worksheet, enters the data using SQL INSERT (is this not possible?) and saves the worksheet, all under programme control.

Thanks in advance...

Ru

Ru,

Just create a new form and paste the below by double clicking on it. I guess this code snippet would help you!

**************Code snippet starts here**************
Rem General Declaration
Dim objExcel As Excel.Application
Dim objWorkBook As Excel.Workbook
Dim objWorkSheet As Excel.Worksheet

Private Sub Form_Load()
    Rem Initialization of variables
    Set objExcel = New Excel.Application
    Set objWorkBook = objExcel.Workbooks.Add
    Set objWorkSheet = objWorkBook.Worksheets("Sheet1")
    Set objWorkSheet = objExcel.ActiveSheet

    objWorkSheet.Range("A1").Value = "Vadivel"
    objExcel.Visible = True ' The created excel workbook would be visible.
    objWorkBook.Close (True) 'This will fire the SaveAs dialog box
End Sub
**************Code snippet ends here**************

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

Thanks, for the code Vadivel.

Can you help me once more?

I get the error

Compile error:

User defined type not defined

I assume I am not declaring or linking to 'something' that permits me to manipulate an excel spreadsheet directly from VB6, but I don't know how or where to do this...

thanks again,

Ru

Ru,

I guess you didn't add reference to the Excel object library.
(Program >> Reference >> Microsoft Excel 9.0 Object Library)
Just add it, the code should work.


Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

Vadivel, you're a star!

Thanks for the tips - I think I'm all set now - the rest (I hope) I can figure out as I go along...

I read on your website that your dad was ill, but is back on his feet now. 'Go mairfhidh se an chead' - an Irish blessing meaning 'may he live to be 100'

All the best for you and yours over the holiday period...

Ru

Ru,

Thanks for wishing my father for long life & thanx for your compliments as well.


Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com