|
楼主 |
发表于 2021-10-26 15:40
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Sub huizong()
Dim arr, n As Byte, i As Integer, wk
Application.ScreenUpdating = False
ChDrive Mid(ThisWorkbook.Path, 1, 1)
ChDir ThisWorkbook.Path
arr = Application.GetOpenFilename(, , , , True)
If IsArray(arr) = False Then Exit Sub
i = 3
For n = 1 To UBound(arr)
i = i + 1
Set wk = Workbooks.Open(arr(n))
With ThisWorkbook.Sheets("汇总")
ThisWorkbook.Sheets("汇总").Cells(i, 4) = Sheets("单项清单").Range("d4")
.Cells(i, 5) = Sheets("单项清单").Range("e4")
.Cells(i, 6) = Sheets("单项清单").Range("f4")
.Cells(i, 7) = Sheets("单项清单").Range("g4")
.Cells(i, 10) = Sheets("单项清单").Range("j4")
.Cells(i, 11) = Sheets("单项清单").Range("k4")
.Cells(i, 14) = Sheets("单项清单").Range("n4")
.Cells(i, 15) = Sheets("单项清单").Range("o4")
End With
wk.Close 0
Set wk = Nothing
Next n
Application.ScreenUpdating = True
End Sub
咋修改为粘贴链接,另外判断名字是否一致要咋加上去
|
|