Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2015
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA Code for saving web page as .pdf

    Hello guys!

    I want to develop the code to do below mentioned actions, but I am kind a struggling here...

    So, my situation:
    I have a table with 3 columns (Headers in Row 1, and following information in all other rows below Row 1):
    1 - Order number (No.),
    2 - "Hyperlink",
    3 - name given for .pdf file

    Task order (if it's done manually):
    1 - Click on hyperlink, (it opens with Internet Explorer)
    2 - Then, File --> Save As... --> Choose destination folder
    3 - Save as .pdf with the name given in Column 3


    Is there someone who can help me a code for this above mentioned task ?

  2. #2
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,078
    Thanks
    0
    Thanked 259 Times in 248 Posts
    Can't answer everything but an issue with IE is its limitation of file types that can be saved.
    IE_Save As.png

  3. #3
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,853
    Thanks
    4
    Thanked 259 Times in 239 Posts
    I would have thought that you would do this by automating Adobe Acrobat. There is a command in Acrobat that captures a url as a PDF. You could then use VBA from Word to read the table and automate the capture of the urls one at a time.

    Do you have Adobe Acrobat installed?
    Andrew Lockton, Chrysalis Design, Melbourne Australia

Tags for this Thread

Posting Permissions

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