[VB] modifying excel files through vb

[saprouzy]

Hey there,

does anyone have a tutorial or something about working with excel through vb?

i've found small examples, but i need a more informative document

thanks.

[egrath]

Hi,

do you intend to use a standalone VB application to modify a excel file or do you want to use vba?

If you are using a VB Standalone Application does the System on which it runs has Excel installed? If so, you can use a OLE Connection to remote control excel to do what you want. A few months ago i've written such a thing but i have to look for it - i will then post a example what i've done.

Egon

[saprouzy]

am using this, i think it will be enough for what i want to do, but i don't mind seeing more examples and/or different ways

Private Sub Command1_Click()
'On Error GoTo err
 Dim objExcel
    Dim objWorkBook
    Set objExcel = CreateObject("EXCEL.APPLICATION")
    Set objWorkBook = objExcel.Workbooks.Open("C:\test.xls")
    For i = 1 To 20
        For j = 1 To 20 
          objExcel.cells(i, j).Formula =  i & ":" & j 
          Me.Caption = "Testing vb-excel - " &  i & ":" & j 
        Next
    Next
    objWorkBook.SaveAs ("C:\test2.xls")
    objWorkBook.Close True
    Set objWorkBook = Nothing
    Set objExcel = Nothing
'    objExcel.quit
Exit Sub
err:
MsgBox "ohh nooo! :( look what happened : " & Error

End Sub

actually my purpose is to avoid designing a Crystal report, similar to excel files that are already done, so i thought about changing the excels directly