Help required please.

I have 2 folders, one is of images, the other folder contains excel workbooks. Each workbook has a corresponding image in the image folder.
I am hoping it is possible to insert the image into the workbook with the same name E.g. 123456.jpg inserted into 123456.xlxs.

As I have thousands of these it would be handy if it could loopthrough the different workbook names and add the relevant image, save then close.
Unfortunately the files are not all currently saved as Jpeg's, some .TIF and .bmp. But this is easy to change if necessary.

My experience of VB is very limited, so as much guidance as you can offer would be great. Thanks