Problem with Macro to insert picture

I have this macro that currently inserts pictures just fine in excel 2007, but we just upgraded to 2010 and now it only inserts the links. So when we e-mail the file out of our local network we get the error message that say the picture has lost it link. I know I need to change the code so that it inserts the pictures as objects but I am not very familiar with VBA and Macros so any help is greatly appreciated.

Please Login or Register  to view this content.

Here is the excel file I am working with: 2014 04 WIRE No Pic.xlsx

The pictures are in a folder that is over 5GB so it is not practical to upload all the pictures. I did however upload two of them: RC2-AH1093.jpgRC2-AH1085.jpg

attach please a sample file for testing

Your code works very well on my excel 2010, but need to remove this line

Please Login or Register  to view this content.