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

[Lerlawrence]

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.

[jolivanes]

Please read the forum rules (at the top). Rule #2 is of interest to you.

[Lerlawrence]

thanks, fixed. I tried to include the link to register and it kept kicking back as a new user not being able to post links...