如何批量某文件夹内所有excel文件的某字眼

lingyuncelia

Sub wordReplace()
Application.Visible = False
Dim fpath As String, fname As String, sht As Workbook
fpath = "d:\t\"
fname = Dir(fpath & "*.xls?")
Do While fname <> " "
Set sht = Workbooks.Open(fpath & fname)
With sht
Cells.Replace What:="1", Replacement:="2"
.Save
.Close
End With
fname = Dir
Loop
Application.Visible = True
End Sub

hzg303

批量某文件夹内所有excel文件的某字眼