|
- Option Explicit
- Sub ToHW_A()
- Dim WKB As Workbook, Rng As Range
- Dim arrData() As Variant
- Dim iRow As Long, iRecs As Long
-
- ' 起始列列号、连续几列
- Const Col_Begin = "D"
- Const iCols = 3
-
- Application.ScreenUpdating = False
-
- ' 从当前工作簿读取数据
- With Sheets("Sheet1")
- ' 无数据则退出
- iRow = .Range(Col_Begin & Rows.Count).End(xlUp).Row
- iRecs = iRow - 1
- If iRecs < 1 Then Exit Sub Else arrData = .Range(Col_Begin & 2).Resize(iRecs, iCols).Value
- End With
-
- ' 写入目标工作簿、表
- Set WKB = Workbooks.Open(ThisWorkbook.Path & "\HW-A.xlsx")
- With WKB.Sheets("HW-A")
- iRow = .Range("B" & Rows.Count).End(xlUp).Row
- Set Rng = .Range("A" & iRow + 1)
- Rng.Resize(iRecs).Value = Date + Time
- Rng.Offset(, 1).Resize(iRecs, iCols).Value = arrData
- Rng.Offset(, 1 + iCols).Resize(iRecs).Value = Format(Date, "yymmdd")
- End With
- WKB.Close SaveChanges:=True
-
- Set Rng = Nothing
- Set WKB = Nothing
- Application.ScreenUpdating = True
- End Sub
复制代码 |
评分
-
查看全部评分
|