|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
加一句循环就可以完成,PageX = pdDoc.GetNumPages - 1,这句是获取PDF页数
Sub PDFRotate()
Dim PDFApp As AcroApp
Dim PDFDoc As AcroAVDoc
Dim PDFPath As String
Dim pdPage
Dim pdDoc
Dim PageX, i As Integer
Const pdRotate0 = 0 '旋转角度
Const pdRotate90 = 90 '旋转角度
Const pdRotate180 = 180 '旋转角度
PDFPath = ThisWorkbook.Path & "\" & "PDF Test.pdf"
Set PDFApp = CreateObject("AcroExch.App")
Set PDFDoc = CreateObject("AcroExch.AVDoc")
If PDFDoc.Open(PDFPath, "") = True Then
Set pdDoc = PDFDoc.GetPDDoc()
PageX = pdDoc.GetNumPages - 1
For i = 0 To PageX
Set pdPage = PDFDoc.GetPDDoc.AcquirePage(i) '旋转转页数 0代表第1页,1代表第2页
Call pdPage.SetRotate(pdRotate180) '旋转角度
Next i
End If
pdDoc.Save 1, PDFPath
Set PDFDoc = Nothing
Set pdDoc = Nothing
Set pdPage = Nothing
On Error Resume Next
PDFApp.Show
AppActivate "Adobe Acrobat Pro"
End Sub |
|