Hi,
Thought I'd share the attached which contains macros to insert hyperlinked file names with images in adjacent cell or in comment from a folder in a column list. VBA code was developed from a number of references as detailed in the comments.
Usage includes: listing files from a folder with hyperlinks; creating an index of photos with hyperlinks to the originals, etc.
Background is that I needed code to list thumbnails of photos in a folder, potentially 100s at any one time, in an excel table which could then be categorised, rated, commented against, etc. Hyperlinks can be either relative or full path. Relative path means that you can send the excel file and original folder to someone else and they can use the excel file as an index.
Its been pretty well tested but use at your own risk. More details in the attached.
Thought I'd share the attached which contains macros to insert hyperlinked file names with images in adjacent cell or in comment from a folder in a column list. VBA code was developed from a number of references as detailed in the comments.
Usage includes: listing files from a folder with hyperlinks; creating an index of photos with hyperlinks to the originals, etc.
Background is that I needed code to list thumbnails of photos in a folder, potentially 100s at any one time, in an excel table which could then be categorised, rated, commented against, etc. Hyperlinks can be either relative or full path. Relative path means that you can send the excel file and original folder to someone else and they can use the excel file as an index.
Its been pretty well tested but use at your own risk. More details in the attached.