Excel Object

[virux]

hi ~!~!

anybody knows how to delete a row/column in my worksheet from a VB program?

and any way to find out all the API to use Excel in VB? any GOOD pointer?

cheers,
virux

[Nitro]

'Here is how you delete a row - deleting row 3.

Private Sub cmdCreateObject_Click()
   Dim xlApp As Object
   Set xlApp = CreateObject("Excel.Application")
   xlApp.Visible = True
   xlApp.Visible = True
   xlApp.Workbooks.Add
    
   Dim int_X As Integer
   For int_X = 1 To 10
    Cells(int_X, 1).Value = int_X
   Next
   xlApp.Rows("3:3").Delete
   'xlApp.Quit
   Set xlApp = Nothing
End Sub