Forum Discussion
Linking photos from a file to a cell in excel with same file name
"I have an excel file that lists a file name. I have a folder of jpeg photos with the same filename located in it. How do i link the excel file to go to the folder, find it, and open up the photo whe...
DWatrHi, sounds like the HYPERLINK function can help you.
If the file path was C:\Users\admin\OneDrive\Desktop\ and cell A2 had the filename of the jpeg photos you could use the HYPERLINK fucntion like so
=HYPERLINK("C:\Users\admin\OneDrive\Desktop\"&A2,"Go there")
This formula would be dynamic and can be copied for all photos with the cell content being the match with the jpeg file.
Alan