|
代码如下:
- Sub ykcbf() '//2023.4.25
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Dim arr, brr(1 To 10000, 1 To 1), crr(1 To 10000, 1 To 1), p, f, l
- b = [{"修改","回退"}]
- p = ThisWorkbook.Path & ""
- Set sh = Sheets("脚本")
- With Application.FileDialog(msoFileDialogFilePicker)
- .Title = "请选择文件夹"
- .InitialFileName = ThisWorkbook.Path & ""
- .AllowMultiSelect = True
- .Filters.Clear
- .Filters.Add "Excel Files", "*.xls?"
- .Filters.Add "All Files", "*.*"
- .Show
- For l = 1 To .SelectedItems.Count
- f = .SelectedItems(l)
- Set wb = Workbooks.Open(f, 0)
- For Each sht In wb.Sheets
- If IsSheetEmpty = IsEmpty(sht.UsedRange) Then
- With sht
- r = .Cells(.Rows.Count, "a").End(xlUp).Row
- c = .Cells(3, 255).End(xlToLeft).Column
- arr = .[a1].Resize(r, c)
- End With
- For j = 2 To UBound(arr, 2)
- If InStr(arr(3, j), b(1)) Then
- For i = 4 To UBound(arr)
- If arr(i, j) <> Empty Then
- m = m + 1
- brr(m, 1) = arr(i, j)
- End If
- Next
- End If
- If InStr(arr(3, j), b(2)) Then
- For i = 4 To UBound(arr)
- If arr(i, j) <> Empty Then
- n = n + 1
- crr(n, 1) = arr(i, j)
- End If
- Next
- End If
- Next
- End If
- Next
- wb.Close False
- Next
- End With
- With sh
- .[h1].CurrentRegion.Offset(1).ClearContents
- .[h2].Resize(m, 1) = brr
- .[i2].Resize(n, 1) = brr
- End With
- Application.ScreenUpdating = True
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|