Macro to import image based on Cell Value

[abellad]

I have a spreasheet with several workbooks. On Cell B6 of the each of the worksheets I have a reference no. Each reference number has its onw sheet. Depending on the value in cell B6 I would like to create a macro to look for images in C:\Images and return the image matching the reference number.

For Eg if i have "27736" in B6 I would like the macro to look for "27736.jpg" in C:\Images and paste the image in range E3:G10.

Any ideas?

Thank you.

 

[BrianB]

Similar to my code here
http://www.mrexcel.com/forum/showthread.php?t=415275

http://www.mrexcel.com/forum/showthread.php?t=187793

http://www.mrexcel.com/forum/showthread.php?t=278935

You basically have to use the full path & file name of the picture.