|
Sub SaveAsPDFWithPageNumber()
'定义变量
Dim ws As Worksheet
Dim pdfName As String, pdfPath As String
Dim pageNumber As Integer, totalPages As Integer
'选择要另存为PDF的工作表
Set ws = ActiveSheet
'设置PDF的保存路径和文件名
pdfPath = "C:\Users\UserName\Desktop\"
pdfName = "MyPDFFile.pdf"
'将工作表保存为PDF
ws.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=pdfPath & pdfName, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=False
'打开保存的PDF文件
Dim acrApp As Object, acrDoc As Object
Set acrApp = CreateObject("AcroExch.App")
Set acrDoc = CreateObject("AcroExch.AVDoc")
acrDoc.Open pdfPath & pdfName, "Acrobat"
acrDoc.BringToFront
'获取PDF的总页数
totalPages = acrDoc.GetNumPages()
'在每页的页脚添加页码
For pageNumber = 1 To totalPages
acrDoc.gotoPage pageNumber
acrDoc.SelectText "Page ", pageNumber
acrDoc.AddText "第" & pageNumber & "页,共" & totalPages & "页"
Next pageNumber
'保存并关闭PDF文件
acrDoc.Save PDSaveFull, pdfPath & pdfName
acrDoc.Close False
'释放对象
Set acrDoc = Nothing
Set acrApp = Nothing
End Sub
|
|