1、新建一个word文本,点击”开发工具“菜单下的”宏“按钮(如没有开发工具可点击”视图“下的宏按钮)
2.输入名称后点击”创建“按钮
3.输入如下代码:
Sub CommandButton1_Click() Application.ScreenUpdating = False '关闭屏幕闪 Dim myFile$, myPath$, i%, myDoc As Object, myAPP As Object, txt$, Re_txt$ Set myAPP = New Word.Application With Application.FileDialog(msoFileDialogFolderPicker) '允许用户选择一个文件夹 myPath = .SelectedItems(1) '读取选择的文件路径 myFile = Dir(myPath & "\*.docx") txt = InputBox("需要替换的文字:") Re_txt = InputBox("替换成:") myAPP.Visible = True '是否显示打开文档 Do While myFile <> "" '文件不为空 Set myDoc = myAPP.Documents.Open(myPath & "\" & myFile) If myDoc.ProtectionType = wdNoProtection Then '是否受保护 .Replacement.Text = Re_txt .MatchAllWordForms = False Application.ScreenUpdating = True
完成后点击 ”保存“,然后关闭
4.回到Word文档,点击宏,运行宏
5.按照向导进行替换过程,等待弹出”全部替换完毕“后即可。
|