|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
lijian8003 发表于 2013-6-5 18:26
您写的下述代码用于循环打开工作簿。现在,欲只循环打开具有“模版_001”、“模版_002”......这样名称的 ... - Sub 循环打开工作簿并运行它的宏()
- Dim p$, arr, f, s$(), srr&(), i&, j&, a
- Application.ScreenUpdating = False
- Open "c:\运行\01.txt" For Input As #1
- s = Split(StrConv(InputB(LOF(1), 1), vbUnicode), vbCrLf)
- Close #1
- ReDim srr(UBound(s), 1)
- For i = 0 To UBound(s)
- a = Split(s(i), " ")
- For j = 0 To 1
- srr(i, j) = a(j)
- Next
- Next
- p = ThisWorkbook.Path & ""
- arr = Array("模版_001", "模版_002")
- For i = LBound(arr) To UBound(arr)
- f = Dir(p & arr(i) & ".xls*")
- If f <> "" Then
- With Workbooks.Open(p & f, 0)
- .Sheets("数据").[a1].Resize(i, 2) = srr
- Application.Run "'" & f & "'!模块1.宏1"
- .Close False '关闭不保存
- End With
- End If
- Next
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|