Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Image download from URLs in a column

0

Hello.

I have a CSV file which contains image URLs in a column. I want to download all images to a zip file. Is it possible? If so, can anyone suggest the steps?

I have attached 2 sample files. One which has only 1 URL per cell & the other which has multiple URLs delimited by a colon (:). The actual file has over 5000 images.

Thanks & Regards.

Ramesh Y. R.

Answer
Discuss

Discussion

My requirement is that all URLs will be from the same site. Can I get the code for it?
LEAPS Jan 24, '18 at 11:21 pm
I think this request goes beyong "Teach Excel". You asked for the steps and I told you.
Variatus (rep: 4889) Jan 25, '18 at 4:00 am
Ok. Thanks. I am not a techie and hence requested. Sorry if I have caused inconvenienceĀ to you.
LEAPS Jan 25, '18 at 9:15 am
Add to Discussion

Answers

0

The first step is to create code to download one of the images. It is easy to imagine that different websites will require different code.

Then, in a second step, the code must be built into a loop so that it can be called repetitively with different URLs. In this step the task is to create robust code that can be expected to deal with the majority of exceptions one might expect when connecting to 5000 websites.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login