+ Reply to Thread
Results 1 to 5 of 5

download files from column of urls

  1. #1
    Registered User
    Join Date
    09-26-2014
    Location
    Vancouver, BC
    MS-Off Ver
    2010
    Posts
    11

    download files from column of urls

    Can someone please, please show me how to download files (pdf & doc) from a column populated by urls into a specific file eg c:\site\pdfs. Is this possible? Many thanks ... c

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: download files from column of urls

    Hello cdumper,

    Does the URL include the the file name?

    Can you post some samples of the URLs or post a copy of your workbook?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    09-26-2014
    Location
    Vancouver, BC
    MS-Off Ver
    2010
    Posts
    11

    Re: download files from column of urls

    sure. They'll be something like (below) in column A. Many thanks ... Chris

    http://www.bccdc.ca/resourcematerial...CareClinic.pdf
    http://www.bccdc.ca/resourcematerial...enterology.pdf
    http://www.bccdc.ca/resourcematerial...aSTIClinic.pdf
    http://www.bccdc.ca/resourcematerial...treetNurse.pdf
    http://www.bccdc.ca/resourcematerial...iaTBClinic.pdf
    http://www.bccdc.ca/resourcematerial...nityHealth.pdf

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: download files from column of urls

    You could give this a try, though it is a bit rough and ready.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  5. #5
    Registered User
    Join Date
    09-26-2014
    Location
    Vancouver, BC
    MS-Off Ver
    2010
    Posts
    11

    Re: download files from column of urls

    Thank you thank you, that gives me a starting point :-)

+ 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. Replies: 3
    Last Post: 02-16-2014, 07:07 PM
  2. Using web query to download data from multiple urls.
    By jackuspi2010 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2013, 07:04 AM
  3. Download images from a list of urls (in excel sheet) to my local disk
    By anto888 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2012, 04:02 AM
  4. Converting text URLs to hyperlinked URLs
    By ranchhand in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2011, 01:46 PM
  5. Replies: 3
    Last Post: 11-07-2005, 05:10 PM

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