Use VBA to Insert Photos into Excel from URL

Learn how to insert photos into an excel spreadsheet from the image address using VBA. In this video I will show you how to write a simple macro that will allow you to insert multiple pictures into excel at once.

If I create your sheet for a video I will send you the video for free!!

[Books I Love] Support the Channel

[Connect with Me]

[Social Media]

[danilobunetto]

Hello, great tutorial. I'm using it. Thanks. What changes can I do to use the code to all the rows of a table and jumping the rows without a link?

[ladsav]

Excelent video in the term of detailed explanation of what are we doing so it helped me to understand how it works. Big thanks.

[elisehill]

This was a success !! Thank you, that was such a helpful video

[jillhodson]

This was great! I was able to create without any problem. Thank you.
Is there a modification needed if the cell range for the pictures has merged cells?

[romekk]

Thank you very much for sharing this. It did work without any issues. I just adapted it to my own code.

[wadeemaghi]

it works, thank you! if I need to skip the empty cell and go to the next cell what should I change in the code?

[miriamfahmi]

Hi, what a useful tool. Thank you. It does not seem to work for MACs however, any tips?

[MrErnicoco]

Thanks for video! I was looking for such explanation very long.
I really like the way you explain so I can repeat and understand more. I wish you great success

[philippebongrand]

Thanks a lot for this super tutorial !
What can I add to center the photos in the column ?
Thanks again for your super explanations !

[Jojosmith]

Excellent. Liked & definately subscribed. Thank you so much for your time to make this video. Could you please kindly teach us how to dynamically load photos from network drive based on user's input. Ex: There are hundreds thousands of products's photos, say user is searching for product #1, photo of this product ID will be loaded automatically from network drive. Thanks a lot for your help

[turnswood]

I've been looking all over for something that does this. I didn't want to copy pictures in and then manipulate them, but from a link, fill in the picture from a link. I'm going to retrieve them from one of my disks, but it's still a hyperlink. Thanks a lot. Irv in Florida

[vjaska]

Very helpful tutorial, thanks - just one question, is there a way of changing the size of the picture in the VBA code so that the pictures don't reach the sides of the cell the picture is located in?

[novapearls]

Very great tutorial!!!
If the link is broken or has no picture is there a code to skip that image and go to the next ?
Thank u!!

[dbknight]

This is so helpful, thank you so much for doing this! I was wondering though, I was trying to accomplish this with a link to a file in my onedrive. I have a picture file in there that I have shared for everyone and I would like to use it for the image. It is giving me an error. Would there be a different procedure for that?

[ΓρηγόρηςΚαλαποθαράκος]

great video! how do I massively import images though? I mean what if I have 1000 products? it is impossible to copy-paste 1000 times the URL for each product. thank you very much.

[francisliossi]

Thanks a lot for this video!! But I still need your help! I'm trying to make the same thing, but using a Google Drive image link. However, i don't know why it doesn't work. Could you please help me?

[gyaninn]

You deserve more value 👍 thanks a lot such a lovely module

[darkentbg]

This is MEGA awesome, is there a way to transport the images to another sheet? I tried to designate a sheet by going Sheets("my sheet name") instead of activesheet, but it doesnt work

[sultanzone]

Great help
Tha Thanks for sharing this

[MNp]

Great Video - I have one problem. I need my image to fit a merged cell. Any help on how this can be done?