G
godyang
Unregistered / Unconfirmed
GUEST, unregistred user!
我就是想把下面的代码在delphi中实现出来。
Sub labtest()
Dim iR, datetime, vatcode
datetime = Range("d2:e2".Value
vatcode = Range("J2:N2".Value
Windows("manage.xls".Activate
iR = Sheets("sheet1".[a65535].End(xlUp).Row + 1
Range(Cells(iR, 1), Cells(iR, 1)).Value = datetime
Range(Cells(iR, 2), Cells(iR, 2)).Value = vatcode
Windows("work.xls".Activate
End Sub
Sub labtest()
Dim iR, datetime, vatcode
datetime = Range("d2:e2".Value
vatcode = Range("J2:N2".Value
Windows("manage.xls".Activate
iR = Sheets("sheet1".[a65535].End(xlUp).Row + 1
Range(Cells(iR, 1), Cells(iR, 1)).Value = datetime
Range(Cells(iR, 2), Cells(iR, 2)).Value = vatcode
Windows("work.xls".Activate
End Sub