I have been reworking a database of parts to automatically fill a form outlined on a separate worksheet. One of the DB parameters is a picture of the part and needs to be put in a certain range of the sheet.

I have a macro that allows the user to select a part from the DB and automatically fills in text parameters, but I cannot figure out how to get the picture reference to work. I tried the second set of code from here

http://www.exceltip.com/st/Insert_pi...el/486.htmlfor

but it could never find the file in the server even when searching for the correct name.

If I already have the picture hyperlinked in the DB, is it possible to just choose to use the hyperlink and place the picture in the specified range?