|
- Sub 汇总信息()
- m = 2
- i = 8
- Dim Xls
- Xls = Dir(ThisWorkbook.Path & "\*.xls") '指定要遍历excel文件的路径及文件类型
- Do While Xls <> ""
- Set Xls = Workbooks.Open(ThisWorkbook.Path & "" & Xls) '打开excel文件
- '==========================
- '对时长申请表进行操作
- Dim info(5) As Variant
-
- Do While Cells(i, 1) <> 0
- i = i + 1
- Loop
- info(0) = Range("C4")
- info(1) = Range("C2")
- info(2) = Range("E2")
- info(3) = Range("C3")
- info(4) = Range("F3")
- info(5) = Range("F5")
- Range(Cells(8, 1), Cells(i - 1, 6)).Select
- Selection.Copy
-
- '取得当前工作簿中全部信息
- '============================
- '写入统计总表中
-
- ThisWorkbook.Activate
- Cells(m, 2).Select
- ActiveSheet.Paste
- Range(Cells(m, 8), Cells(i + m - 9, 8)) = info(0)
- Range(Cells(m, 9), Cells(i + m - 9, 9)) = info(1)
- Range(Cells(m, 10), Cells(i + m - 9, 10)) = info(2)
- Range(Cells(m, 11), Cells(i + m - 9, 11)) = info(3)
- Range(Cells(m, 12), Cells(i + m - 9, 12)) = info(4)
- Range(Cells(m, 13), Cells(i + m - 9, 13)) = info(5)
- Xls.Close 0
- Xls = Dir '下一个excel文件
- Loop
- Set Xls = Nothing '释放变量内存
- End Sub
复制代码 在循环的时候出错了,进不去,这是为什么啊?求大神解答 |
|