|
楼主 |
发表于 2023-3-1 20:55
|
显示全部楼层
本帖最后由 dzsrmyh 于 2023-3-1 20:57 编辑
你好,非常感谢,现在还有一点问题,就是在文件夹中除了这两个文件外,还有很多文件,可否在下面代码中添加代码指定该文件夹中的某一文件
Sub test()
Dim f, fso, dic
Set dic = CreateObject("scripting.dictionary")
Set fso = CreateObject("scripting.filesystemobject")
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each f In fso.getfolder(ThisWorkbook.Path).Files
If InStr(f.Name, ThisWorkbook.Name) = 0 Then
With Workbooks.Open(f)
brr = .Sheets(1).UsedRange
.Close False
End With
For j = 7 To UBound(brr)
dic(brr(j, 3)) = brr(j, 7)
Next j
End If
Next f
arr = Sheets(1).UsedRange
For x = 4 To UBound(arr)
If dic.exists(arr(x, 3)) Then
arr(x, 4) = Val(arr(x, 4)) - dic(arr(x, 3))
End If
Next
Sheets(1).UsedRange = arr
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
|
|