Downloading images from links in a spreadsheet

**outomyelement** · 05-23-2012, 01:49 PM

First of all, thanks for any help on this. I've been racking my brain on how to do this and I cannot figure it out for the life of me.

The company that I work for has tasked me with setting up an online store. Our major supplier sent a spreadsheet with 3,000+ products with a column of URLs for each product image. I'd love to be able to figure a way to initiate a download of all links to a specific folder for all URL's in that column. Is that possible?

**Chippy** · 05-23-2012, 02:17 PM

URLDownloadToFile should do it. Search the web/this forum and you should find a few examples.

**outomyelement** · 05-23-2012, 05:17 PM

I blame it on my ignorance, but I don't know VBS programming. I tried to download the file and was able to open the vbs file as a macro, but it's pretty much foreign to me. Is there any way to get a macro enabled excel file that is blank that I can insert hyperlinks into that would work?

**outomyelement** · 05-24-2012, 10:33 AM

OK, I figured out a better way. I was able to use Mass Downloader to load the URL's into a text file and it worked like a charm! Thanks for your help!