为了正常的体验网站,请在浏览器设置里面开启Javascript功能!

word2010批量删除页眉页脚VBA

2017-09-26 3页 doc 15KB 135阅读

用户头像

is_321635

暂无简介

举报
word2010批量删除页眉页脚VBAword2010批量删除页眉页脚VBA Sub 批量删除文件夹里面所有Word文档的页眉页脚() Dim Fdlg As FileDialog, Fl Dim Fso, Fld, Fln, Wk Set Fdlg = Application.FileDialog(msoFileDialogFolderPicker) With Fdlg .Title = "选择要处理目标文件夹" & "——(删除里面所有Word文档的页眉页脚)" -1 Then If .Show = MyPath = .SelectedI...
word2010批量删除页眉页脚VBA
word2010批量删除页眉页脚VBA Sub 批量删除文件夹里面所有Word文档的页眉页脚() Dim Fdlg As FileDialog, Fl Dim Fso, Fld, Fln, Wk Set Fdlg = Application.FileDialog(msoFileDialogFolderPicker) With Fdlg .Title = "选择要处理目标文件夹" & "——(删除里面所有Word文档的页眉页脚)" -1 Then If .Show = MyPath = .SelectedItems(1) Else Exit Sub End If End With Set Fso = CreateObject("Scripting.FileSystemObject") Set Fld = Fso.GetFolder(MyPath) Set Fln = Fld.Files For Each Wk In Fln Set myDoc = Documents.Open(FileName:=Fld & "\" & Wk.Name) If ActiveWindow.View.SplitSpecial <> wdPaneNone Then ActiveWindow.Panes(2).Close End If If ActiveWindow.ActivePane.View.Type = wdNormalView Or ActiveWindow. _ ActivePane.View.Type = wdOutlineView Then ActiveWindow.ActivePane.View.Type = wdPrintView End If ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader Selection.WholeStory Selection.Delete Unit:=wdCharacter, Count:=1 Selection.WholeStory With Selection.ParagraphFormat .Borders(wdBorderLeft).LineStyle = wdLineStyleNone .Borders(wdBorderRight).LineStyle = wdLineStyleNone .Borders(wdBorderTop).LineStyle = wdLineStyleNone .Borders(wdBorderBottom).LineStyle = wdLineStyleNone With .Borders .DistanceFromTop = 1 .DistanceFromLeft = 4 .DistanceFromBottom = 1 .DistanceFromRight = 4 .Shadow = False End With End With With Options .DefaultBorderLineStyle = wdLineStyleSingle .DefaultBorderLineWidth = wdLineWidth075pt .DefaultBorderColor = wdColorAutomatic End With If Selection.HeaderFooter.IsHeader = True Then ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageFooter Else ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader End If Selection.WholeStory Selection.Delete Unit:=wdCharacter, Count:=1 ActiveWindow.ActivePane.View.SeekView = wdSeekMainDocument Selection.Sections(1).Footers(1).PageNumbers.Add PageNumberAlignment:= _ wdAlignPageNumberRight, FirstPage:=True ' 以上可以换成是你自己录制的宏 ' C公共部分的代码 Application.DisplayAlerts = False '强制执行“是” 'ActiveDocument.Saved = True'强制执行“否” ActiveDocument.Close '退出 Next End Sub
/
本文档为【word2010批量删除页眉页脚VBA】,请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑, 图片更改请在作品中右键图片并更换,文字修改请直接点击文字进行修改,也可以新增和删除文档中的内容。
[版权声明] 本站所有资料为用户分享产生,若发现您的权利被侵害,请联系客服邮件isharekefu@iask.cn,我们尽快处理。 本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用。 网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。

历史搜索

    清空历史搜索