|
本帖最后由 phz1234 于 2012-7-16 21:18 编辑
求助:批量删除某文件下所有工作簿中所有工作表标签的特定符号(比如空格等)?
- Sub 删除工作表标签中特定符号()
- Dim wb As Workbook, sht As Worksheet, f$, fol, s$
- With Application.FileDialog(msoFileDialogFolderPicker)
- If .Show = False Then Exit Sub
- fol = .SelectedItems(1) & ""
- End With
- s = InputBox("请输入要删除的字符", "输入指定字符", " ")
- If s = "" Then Exit Sub
- f = Dir(fol & "*.*")
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Do While f <> ""
- If fol & f <> ThisWorkbook.FullName Then
- Set wb = Workbooks.Open(fol & f)
- For Each sht In ActiveWorkbook.Sheets
- sht.Name = Replace(sht.Name, s, "")
- Next
- wb.Save
- wb.Close
- End If
- f = Dir
- Loop
- MsgBox "已经完成所有操作~!", vbInformation, "完成"
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- End Sub
复制代码打开工作簿,点击那个按钮,按提示操作就可以了。
|
|