+ Reply to Thread
Results 1 to 6 of 6

Print content of hyperlinked PDFs

  1. #1
    Registered User
    Join Date
    10-29-2010
    Location
    Chichester, England
    MS-Off Ver
    Excel 2003
    Posts
    13

    Print content of hyperlinked PDFs

    Good Morning,

    I have a list of hyperlinks to PDF documents and would like to have an automated way to do the following:

    1. Open Link
    2. Print Content
    3. Close PDF
    4. Move to next link in next cell and repeat 1-3

    Please help!!!

    Thanks,

    Banyard2000

  2. #2
    Registered User
    Join Date
    03-25-2009
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    49

    Re: Print content of hyperlinked PDFs

    This is the code im using, i think i got the base from it from this forum then i have just changed it to fill my needs

    1. "ToPrint" is the range of cells that the code should loop through
    2. The Line1 Line2 i only use because sometimes my cells is empty or have a "-" in it and if it does i just want it to continue to the next cell
    3. the filepath to your pdf reader you have to set yourself
    4. The paths for the "temp" printlog you have to change to your choice of filepath

    Let me know if you wondering about something


    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-29-2010
    Location
    Chichester, England
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Print content of hyperlinked PDFs

    Hi,

    Thanks for posting this code for me.

    However I do have a problem. See the attached file for an error that appears in Adobe Reader. Please help!!

    Thanks,

    Banyard2000
    Attached Images Attached Images

  4. #4
    Registered User
    Join Date
    03-25-2009
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    49

    Re: Print content of hyperlinked PDFs

    Hmm, if you click your hyperlink manually, does it open correctly at that point?

    Have you given your range the correct name ie ToPrint, and also selected the right range?

  5. #5
    Registered User
    Join Date
    10-29-2010
    Location
    Chichester, England
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Print content of hyperlinked PDFs

    I receive an initial message before clicking OK to continue. Please see attached.

    Thanks.
    Attached Images Attached Images

  6. #6
    Registered User
    Join Date
    03-25-2009
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    49

    Re: Print content of hyperlinked PDFs

    I get this message when i open my hyperlinks in another workbook, but not the one im running this code in.

    I wonder if it could be a security setting that you can turn of. Im not really sure about this.

    Otherwise it would be possible to put in a keystroke in the script, but it would make the script alittle more unreliable i think

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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