Using Macro to add google's first image link to Excel

Hello Everyone


i'm trying to use Macro to add the first image link from google to b1 for every a1 value.


i have more than 1000 value that need images.

can you please help on that?

i use windows 10 and MS 365

please support

thanks

Originally Posted by YasserKhalil

Hello try this code

Please Login or Register  to view this content.

Hello Sir

Thanks for you reply, i'm receiving the below error. can you please advise?

wQmkqDj.png

Thanks

I have solved the above error. but it's giving me Google's logo image.

Can you please help me modify it to get the accurate image? Plus I need to modify it to get large images. Can you please support on that?

Yasser,
The first error is caused by using early binding. The OP has to reference these classes or objects in their PC before they run the code. It is best practice to use early binding for development as you can benefit from Intellisense and change it to late binding when you ship it to a client. So, dim all objects as genetic.

Originally Posted by YasserKhalil

Sorry for being late in reply
It was working before and I tried to fix it but couldn't find a way
Waiting for experts to share

I have posted a thread here too
http://chandoo.org/forum/threads/gra...-search.35548/

Hello Sir,

I'm using the below code, it was given to me on this thread: https://stackoverflow.com/questions/...03118_45809181
however, this code works fine for images, except that it stops when it comes to a value that can't be found on google.
can you modify it to not stop even while facing such cells?

HTML Code: 

for example: I have 1000 values and A30 value can't be found on google so the macro will stop on cell A30 and give you an error.
can you fix that Sir?

Thanks