Need help pulling pictures from folder to excel sheet.. open for details

[iowitz]

I have an excel sheet where column "B" has a list of style numbers . I also have a folder with pictures of each product and file name of the pictures are the product code. I would like to place the picture of each product in column "A" beside their respective codes. If possible, I would also like to reformat the pictures so they fit in the cell. Size= (3.00 x 3.85)

I want to be able to press for example :CTRL Q and all the the pictures will pull from the folder on my PC and populate in column A next to their respective style # in column B.

Need a Macro that can run this.
I don't really know where to start and any help would be greatly appreciated!
If anyone could write this code that would be great.
Thanks

 

[VoG]

Cross posted Pull pictures from folder to excel sheet...HELP

Please read Excelguru Help Site - A message to forum cross posters