Guys the code below does exactly what I want in excel 2007 but not quiet in excel 2010. I do not know what changed but it links the picture I am looking up instead of saving it as a picture. What should I do? I searched and searched on the net but couldn't find a working solution for myself. What do you suggest to save the pictures as pictures not links to the path? I want to be able to send this excel file via e-mail to my colleagues and want them to see everything they need on the excel sheet not linked to certain folders.
Thanks in advance guys.
Bookmarks