|
Sub 批量替换()
Application.ScreenUpdating = False
Dim wb As Excel.Workbook
f = Dir(ThisWorkbook.Path & "\*.xl*") '生成查找EXCEL的目录,可以适应不同版本
Do While f <> "" '在目录中循环
If f <> ThisWorkbook.Name Then '如果不是打开的工作簿
Set wb = Workbooks.Open(ThisWorkbook.Path & "\" & f) '依次打开目录工作薄
Sheets("Sheet1").Select
ActiveWorkbook.Save
Cells.Replace What:="地基承载力", Replacement:=" ", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
wb.Close True
End If
f = Dir
Loop
Application.ScreenUpdating = True
End Sub
网上找的这段代码,可以运行,想让显示在表格中,最好能一次多替换几个。拜托各位大佬了,十分感谢
没有附件,猜的。
- Sub 批量替换()
- Dim arr, i&
- arr = ActiveSheet.[a1].CurrentRegion
- Application.ScreenUpdating = False
- Dim wb As Excel.Workbook
- f = Dir(ThisWorkbook.Path & "\*.xl*") '生成查找EXCEL的目录,可以适应不同版本
- Do While f <> "" '在目录中循环
- If f <> ThisWorkbook.Name Then '如果不是打开的工作簿
- Set wb = Workbooks.Open(ThisWorkbook.Path & "" & f) '依次打开目录工作薄
- Sheets("Sheet1").Select
- ActiveWorkbook.Save
- For i = 2 To UBound(arr)
- Cells.Replace What:=arr(i, 1), Replacement:=arr(i, 2), LookAt:=xlPart, _
- SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
- ReplaceFormat:=False
- Next i
- wb.Close True
- End If
- f = Dir
- Loop
- Application.ScreenUpdating = True
- End Sub
复制代码
|
-
|