I am only a beginner with VBA and the following problem is beyond me.

I have several spreadsheets with two columns; Column A is Names and Column B is a reference to an image. I then have a folder with the images (each image is named with the same reference as column B). The image folder is stored in the same place as the Excel file (Parent folder has Excel file + Image folder). I would like to create an image directory, which means that I would like to pull the images from the folder and put them in the appropriate row in Column C.

The program should insert images for all Column B rows that contain data (I might have an image without a name). The images should re-size to the cell height and width (125x20).

The program should also compress the image size to 96 ppi. I don't care if this happens after each image or after inserting all images.