+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Link specific PDF page in excel

  1. #1
    Registered User
    Join Date
    10-05-2011
    Location
    DMHI
    MS-Off Ver
    Excel 2007
    Posts
    7

    Lightbulb Link specific PDF page in excel

    Hello guys,

    I'm new to this forum and excel in general,but i really need help with this.
    I sorted out about 4000 pages of PDF that contain company standards i summarized them into a table with 550 rows ( each row represents 1 standard ) and now i need to add a column with links.
    the hyperlink doesn't let me use the #page=X,only if the pdf is on a site
    i solved this by saving the file to the Htm format now the links work but i have to create 549 links (i created 1 for testing ) any ideeas how to do that faster ? like a macro in VBA or something.
    I made a macro in vba that works but i have to make a macro for every link and that's 549 macros. Could i make 1 macro that could take a value from a hidden column and use it as the page number ?
    Thanks.

  2. #2
    Registered User
    Join Date
    10-05-2011
    Location
    DMHI
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Link specific PDF page in excel

    Can i get some help PLEASE, i really need to solve this problem today.
    Thanks

    L.E
    Thanks for nothing guys, i'm sure i'll comeback here for more help.
    NOT
    Btw i solved the problem myself with the help of a friend but i'm telling nobody.
    Last edited by Mike Hawk; 10-07-2011 at 09:22 AM.

  3. #3
    Registered User
    Join Date
    01-25-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Excel 2007 : Link specific PDF page in excel

    create a function as below:

    Function OpenPDFpage(myLink As String, TargetPage As Double)
    Set objIE = CreateObject("InternetExplorer.Application")
    With objIE
    .Navigate myLink & "#page=" & TargetPage
    .Visible = True
    End With
    End Function

    In excel enter a formula
    in column C
    =IF(D9="Y",OpenPDFpage(E9,F9),"-")

    D, Y or N
    E, Full path and file name
    F, Page no


    thanks,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1