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 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 Haytham,
Is there a easy way to do this for a row instead of a column?
ie. a range of image URLs from B2 to M2 and to show the image beneath it at C2 to M2?
I'm not too familiar with VBA but couldn't get the VBA to work when I changed the columns to rows and rows to columns in the code.
Thank you,
MichaelMSDON25 Don't know if this might help, but I found a video online that just used the 'image' function. And it worked just fine, if you are not too fuzzy on the dimensions of the image. I just made the rows a bit bigger so the logos show reasonably normal.
I have a column of image attachments links in my workbook and would like to load the actual image in the column. It always happen after I tried to export from .aspx to excel.
Is there a way to show image inside the cell?
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, 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
I tried something similar to that. The issue I had was when I ran the module, the images loaded onto the spreadsheet in a stack or layered on top of each other instead of in cells. Do you know if I could make that happen?
You can easily change the Height and Width to make the images fit the cells.
Try to change the Height from 100 to 30 and the Width from 100 to 60.
.Width = 60
.Height = 30I got the VBA to work. My questions is there a snippet that can be added to the VBA code to make the image insert into a specif cell? For example, if the url is in cell C3 and I want the image to be in cell D3
