k访谈提纲
295 字
1 分钟
k访谈提纲
k访谈提纲
Sub 插入访谈(x) Path = ActiveDocument.AttachedTemplate.FullName Application.Templates(Path).BuildingBlockEntries(x).Insert Where:=Selection.Range, RichText:=True With ActiveDocument.PageSetup .Orientation = wdOrientPortrait .TopMargin = CentimetersToPoints(2.54) .BottomMargin = CentimetersToPoints(2.54) .LeftMargin = CentimetersToPoints(3.17) .RightMargin = CentimetersToPoints(2.7) .HeaderDistance = CentimetersToPoints(1) .FooterDistance = CentimetersToPoints(1.3) End With ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader Selection.WholeStory Selection.Delete Application.Templates(Path).BuildingBlockEntries("访谈页眉").Insert Where:=Selection.Range, RichText:=True ActiveWindow.ActivePane.View.SeekView = wdSeekMainDocument Selection.WholeStory Selection.Range.ListFormat.RemoveNumbers NumberType:=wdNumberParagraph ActiveDocument.Sections(1).Footers(wdHeaderFooterPrimary).PageNumbers.Add PageNumberAlignment:=wdAlignPageNumberCenter, FirstPage:=True With ActiveDocument.Sections(1).Footers(wdHeaderFooterPrimary) '进入页脚编辑状态 .Range.Font.Size = 9 .Range.Font.Name = "宋体" .Range.Collapse Direction:=wdCollapseEnd End WithEnd SubSub 财务负责人(control As IRibbonControl) Call 插入访谈("财务负责人")End SubSub 采购负责人(control As IRibbonControl) Call 插入访谈("采购负责人")End SubSub 人力负责人(control As IRibbonControl) Call 插入访谈("人力负责人")End SubSub 生产负责人(control As IRibbonControl) Call 插入访谈("生产负责人")End SubSub 投融资负责人(control As IRibbonControl) Call 插入访谈("投融资负责人")End SubSub 销售负责人(control As IRibbonControl) Call 插入访谈("销售负责人")End SubSub 研发负责人(control As IRibbonControl) Call 插入访谈("研发负责人")End SubSub 总经理(control As IRibbonControl) Call 插入访谈("总经理")End SubSub 独立董事(control As IRibbonControl) Call 插入访谈("独立董事")End SubSub 内审负责人(control As IRibbonControl) Call 插入访谈("内审负责人")End Sub支持与分享
如果这篇文章对你有帮助,欢迎分享给更多人或打赏支持!
相关文章智能推荐
1
【VBA案例001】实现VLOOKUP功能
程技2023-10-23
2
【VBA案例002】一对多查询
程技2023-10-23
3
【VBA案例003】模糊查询
程技2023-10-23
4
【VBA案例004】自动填充表单
程技2023-10-23
5
【VBA案例005】自动汇总表单
程技2023-10-23
随机文章随机推荐
樊笼










