Forum Discussion
Convert image url to actual image in excel
I have a column of image URLs in my workbook and would like to show the actual image in the next column. Is there a formula or add in that can be used?
Hi, I have a file having one column consist of many URLs and in next column I wish to convert these URLs into real images. I am using office 2007. Please find the file as attached. Kindly help me to convert this file . Looking forward.
Haytham Amairah wrote:Hi Michael,
No formula can help in this regard!
You need a VBA code or a third-party add-in to view these images.
Please check out this link.
Hope that helps
Hi rsinghal2019,
It seems that the links in the file aren't valid when you open them in the browser!
Therefore, I don't think that the solution is applicable to them.
Hi this code is very helpful thank you
I was wondering if there is a way to actually download the images?
if i am understanding this the images we are seeing are just being generated from the link but are not hard files on the computer?
Thanks
Hi,
After you run the code, these pictures get saved locally in the workbook.
If you want to extract them into a folder outside Excel, the trick is to save the workbook as a Webpage (*htm; *html) using the Save As dialog box.
After then, go to the webpage folder and find them inside it.
Regards
Hi,
I have the same problem and I got help from your awesome solution, but the last problem is that I need the original size of the pictures. How can I have the Original size of them?
Best
