VBA to Import images from a selected folder including filename

[Stalley]

Hello there,

I have been trying to identify a way to automate importing images from a local folder into a specific sheet.
I am not too familiar with VBA's (or editing them atleast!) and have tried using a few found in other topics here and whilst a few did work, I was unsure how to determine location, file name and size.

Screenshot example of what I'm looking for.
The formatting is just a rough guide, but in essence I would be happy just to have the pictures and file names in an orderly structure. The images would need to be a predetermined size.

Any help is greatly appreciated.

 

[davesexcel]

If you scroll down to similar threads, you will see similar threads