|
- Sub Macro1()
- Dim mypath$, wj$, arr, wb As Workbook
- mypath = ThisWorkbook.Path & ""
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- arr = Range("a3").CurrentRegion
- wj = Dir(mypath & wj)
- Do While wj <> ""
- If wj <> ThisWorkbook.Name Then
- Set wb = GetObject(mypath & wj)
- For i = 1 To wb.Sheets.Count
- For j = 1 To UBound(arr)
- wb.Sheets(i).UsedRange.Replace arr(j, 1), arr(j, 2)
- Next
- Next
- Application.Windows(wb.Name).Visible = True
- wb.Close 1
- End If
- wj = Dir
- Loop
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- End Sub
复制代码 |
评分
-
查看全部评分
|