Open an specific pdf bookmark from excell RRS feed

  • Question

  • Hello,

    If anyone has successfully managed to open a pdf file at a specific bookmark.

    This is my rather clumsy attempt:

    Public Sub Open_PDF_At_Page_No()
    Dim sPDFfile As String
    Dim sAdobeCommand As String
    Const cAdobeReaderExe As String = "C:\Program Files (x86)\Adobe\Acrobat Reader DC\Reader\AcroRd32.exe"
    sPDFfile = "D:\psv5000test.pdf"
    sAdobeCommand = " /a ""pagemode=bookmarks=0101-3011 Model"" "
    Shell cAdobeReaderExe & sAdobeCommand & Chr(34) & sPDFfile & Chr(34), vbNormal 'vbMinimizedNoFocus  'open minimized ', vbNormal
    End Sub

    Thursday, September 8, 2016 3:49 PM

All replies

  • Hi,

    Thanks for posting here.

    This forum(Excel for Developers) for Developer discussions and questions involving Microsoft Excel, like developing issues related with Excel Object model.

    Since your issue is not related with Excel Object model, I do apologize that we might not offer a better solution or workaround. And I would move this thread into VBA forum.



    Friday, September 9, 2016 7:20 AM