+ Reply to Thread
Results 1 to 2 of 2

Download all links in sheet

  1. #1
    Registered User
    Join Date
    11-12-2020
    Location
    NH, USA
    MS-Off Ver
    2016
    Posts
    1

    Download all links in sheet

    Hi,

    In column A, I have thousands of URLs that go to a pdf on the web.
    In column B, I have what I would like the downloaded pdfs to be named.

    Does anyone have a way to download all of the pdfs and name them with Column Bs values?

    Thank you,
    Jim

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Download all links in sheet

    take a look at the small sample I gave to another gentleman, here:

    https://www.excelforum.com/excel-pro...ml#post5423951

    If you have your browser settings for downloads set to save file, always, it is as simple as going to each URL via the method shown in the link above and pushing the save button. but of course, that would take forever. I seriously doubt there is a way to push the save button in a browser dialog automatically with any language, because the code that drives those windows are built into the browser software, and every browser runs off of proprietary platforms. now, if you HAD access to a URL like the following one, which lists nothing more than a bunch of links to different downloads of various package types, you might be able to bypass the dialog stopping points I just mentioned:

    https://www.python.org/downloads/release/python-390/

+ 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 download links in columns & name files with script
    By pdoyon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2018, 11:54 PM
  2. Download Images from Links
    By fitkhan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-13-2015, 03:52 AM
  3. Download PDF Links
    By Jackcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2014, 05:53 AM
  4. [SOLVED] Image download from links in column A
    By fitkhan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-21-2014, 02:18 PM
  5. download all links within an excel document
    By space108th in forum Excel General
    Replies: 5
    Last Post: 08-20-2012, 06:58 AM
  6. Download entire column of image links
    By janschepens in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2011, 08:20 PM
  7. [SOLVED] i want to download tif files one after the other links in excel
    By cncmac in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2006, 01:50 PM

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