Displaying File name as text in seperate column after adding photo with Shapes.AddPicture

Any thoughts on how I can get a filename to print next to my photos? the below macro is something I found and works like a charm to embed the pictures but while I am sure I can get a corresponding filename I can't get it to work. I have folders with 100's of photos and would just love to be able to have a corresponding column of filename for searcheability and sorting.

The end result is hopefully a photo catalog of sorts for an insurance appraiser.

Love to hear any ideas!

Please Login or Register  to view this content.