Forum Discussion
Convert image url to actual image in excel
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 = 30
I 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
Hi Michael,
The code is already programmed to place the image next to the link in the adjacent cell.
This is the result that I got when I run the code.
Isn't that what you asking for?
The code works for some URL and not for other. Sometimes i need to click and open the URL so it could "read" and output the image on excel.
Could you please help me with this problem?
I'm sorry, I meant that the images are not placed in the cells. They are floating and stacked on top of each other. Since I have over 1000 urls to convert, I wanted to know if there's a way to place the resulting images in cells.
