Private Sub Command1_Click()
Set ox = CreateObject("excel.application")
Set ob = ox.workbooks.open("c:\bb.xls")
ox.Visible = True
ob.sheets(2).Activate
Set oc = ob.ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell)
x = oc.row
y = oc.Column
For i = 1 To 5
ob.ActiveSheet.Cells(x + 1, i) = i
Next i
ox.Save
ox.Quit
End Sub
至于数据类型,请查阅Excel帮助中的与编程有关的知识部分。
我也是从那里学到的
Private Sub Command1_Click()
Set ox = CreateObject("excel.application")
Set ob = ox.workbooks.open("c:\bb.xls")
Set oc = ob.ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell)
x = oc.row
y = oc.Column
For i = 1 To 5
ob.ActiveSheet.Cells(x + 1, i) = i
Next i
ox.Save
ox.Quit
End Sub
不知道这样是否满足你的要求