Nguyên văn bởi NoFear87
Xem bài viết
Public excel As excel.Application
Public book1 As Workbook
Public sheet1 As Worksheet
Public sheet9 As Chart
Public HANG As Integer
Public COTSHEET1 As Integer
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
Dim tensheet
Set tensheet = gTagDb("tensheet")
Select Case tensheet
Case 1
sheet1.Range("a1", "e" & HANG).Borders.LineStyle = 1
sheet1.PrintOut
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
sheet1.Cells(HANG, COTSHEET1 - 4) = Val(sheet1.Cells(HANG - 1, COTSHEET1 - 4)) + 1
sheet1.Cells(HANG, COTSHEET1 - 3) = gTagDb("system\DateAndTimeString")
sheet1.Cells(HANG, COTSHEET1 - 2) = a / 10
sheet1.Cells(HANG, COTSHEET1 - 1) = b
sheet1.Cells(HANG, COTSHEET1) = c
Mấy đoạn code trên trích từ luận văn của mình, chỉ mang tính tham khảo code. Bạn có thể dựa vào mấy đoạn code đó mà phát triển thêm.
Comment