Saving images in an excel sheet

[gm13958]

I load to a file an image that is stored on the web.
Then I import this image to excel, but actually, with the cose I am using I do not import the image but just the link to it.

This is the code

Please Login or Register  to view this content.

Since this code works in a loop, at the end of it the latest image loaded is the only one I can see.

Is there a way to store images in the Excel file?

[Leith Ross]

Hello gm13958,

All the pictures are on the worksheet. The code stacks the pictures on top of each other in the same cell. That is why only the last one is visible. You can click and drag the pictures to new locations on the worksheet or move them using code.

[gm13958]

Hello gm13958,

All the pictures are on the worksheet. The code stacks the pictures on top of each other in the same cell. That is why only the last one is visible. You can click and drag the pictures to new locations on the worksheet or move them using code.

I am not sure about this. If I cancel "c:\tmp\img.jpg" I do not see any image on the sheet.