Store images in Excel

**gm13958** · 02-28-2011, 08:45 AM

I am using excel 2010 and I need to store images in an excel file (I mean, really store and not to have a link to an image".

Suppose I have an image in "C:\img.jpg".
I insert the image thru the menu (Insert/Image) and then close the excel file and delete the image. If I reopen the excel file I can see the image in it. This means the image is stored in it.

Since I want to execute this process I have recorded the macro getting the following code:

Please Login or Register  to view this content.

If I execute the above code and then save the excel file and delete the image, when I reopen the excel file instead of seeing the image I get an error message saying that the link to the image is wrong. It clear that in this case the image has not been stored but just the link to it.

Any idea about the way to store images using vba?

**romperstomper** · 02-28-2011, 10:17 AM

It seems to be a bug in 2010. I suggest you use Shapes.AddPicture instead as that allows you to specify whether you want to link to the file or embed it.

**gm13958** · 02-28-2011, 10:50 AM

Thank you for your answer. Your solution works. However I have to pass as parameters the size in pixel of the image and I do not have this information. How can I do?