+ Reply to Thread
Results 1 to 2 of 2

Macro to open a column of hyperlinks and save the PDFs

  1. #1
    Registered User
    Join Date
    04-20-2017
    Location
    Houston, TX
    MS-Off Ver
    13
    Posts
    1

    Lightbulb Macro to open a column of hyperlinks and save the PDFs

    Hi! I have a excel spreadsheet which has 1000+ of hyperlinks in column B. When I click on each hyperlink, it opens in Internet explorer as a PDF. I have to save each individual file every time by a name in column C. Can somebody help me create a macro or VBA that'll automate this process?

    Thanks!

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,259

    Re: Macro to open a column of hyperlinks and save the PDFs

    Hi beatricehuang

    Please upload a sample workbook and we'll gladly assist....Need to know what we are dealing with.
    Originally Posted by Pete_UK
    To attach a file, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to save Word documents as PDFs using Excel macro?
    By utexas24 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-23-2017, 12:45 PM
  2. open , save & close multiple hyperlinks VBA
    By bkay25 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-18-2016, 08:58 AM
  3. VBA CODE - open save hyperlinks
    By bkay25 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 04-29-2016, 10:42 AM
  4. [SOLVED] Excel slow open/save i think because of hyperlinks??
    By hermarjan in forum Excel General
    Replies: 24
    Last Post: 07-14-2013, 08:36 AM
  5. Macro to save excel worksheets as pdfs and change hyperlinks to work in pdf format
    By crnadeau4 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-06-2013, 12:18 PM
  6. open and and print .pdfs in column D
    By johnson1421 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2012, 07:52 AM
  7. Macro Needed to Loop, Save, and Name Excel Files as PDFs
    By ahkarchem in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2012, 10:46 AM

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