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
Printable View
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
Code:'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