download all links within an excel document

**space108th** · 12-23-2009, 03:53 PM

Thank you for reading

My objective is to be able to mass download images via hyperlink.

I have an excel file that has all the links to the webpages that contain the pictures I need to download. So, I save the excel file as a webpage so that I can use a program like downthemall to go to each image and download them, here is the problem. When downthemall downloads them it only downloads them as a .htm file. However if I click on each link, it does forward me to the site and the picture does show and I can save the image manually. I am trying to figure out a way to be able to download all the images without having to manually click each link, as I have almost 2k images needed to download. I also wanted to add that you have to log into the webpage that the links are forwarded too. Any help would be greatly appreciated. Thank you for your time.

**mrice** · 12-28-2009, 08:13 AM

The following code should download files for all the hyperlinks for Excel running in normal mode.

Please Login or Register  to view this content.

**limahab** · 10-15-2011, 01:21 AM

The LocalFilename variable isn’t clearing each time around the loop (it just kept growing, appending the previous filenames to the newest one), so I added a line, LocalFilename = “” to clear it before Next Hyperlink.

Also, make sure there is no other data in the sheet except URLs. For me at least, when i had other data in the sheet the macro would not work.

**ONGExcel** · 08-20-2012, 06:42 AM

Hi mrice,

I am rather thick at the fancier side of excel - and need this desperately as well - where would I put the code you posted?

Kind regards, Lorna

**arlu1201** · 08-20-2012, 06:54 AM

Lorna,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.