Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2740
  • Last Modified:

Download multiple files are once from multiple links in Excel

Experts,
I have a large Excel spreadsheet with 1000's of links to an image (pdf files). I would like to download them all without having to click each one of the click. Is there any tool that will help me with this?
0
cpatelx
Asked:
cpatelx
  • 2
1 Solution
 
Zsolt PribuszCommented:
If those links are hyperlinks in excel, then you can use a macro to extract them.
I found this example of a macro that will find each hyperlink in a worksheet, extract each one's URL, and stick that URL in the cell directly to the right of the hyperlink.
Sub ExtractHL()
    Dim HL As Hyperlink
    For Each HL In ActiveSheet.Hyperlinks
        HL.Range.Offset(0, 1).Value = HL.Address
    Next
End Sub

Open in new window


After links are extracted, you can use some mass downloader application  to get the files, like http://downstairs.dnsalias.net/massdownload.html
0
 
cpatelxAuthor Commented:
Perfect!!!!! Thank Zsolt
0
 
cpatelxAuthor Commented:
Hello Zsolt Pribusz,
Massdownload is throwing  Exception: IOHandler value is not valid on downloading. Please tell me know your thoughts on this
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now