Forum Discussion

DWatr's avatar
DWatr
Copper Contributor
May 08, 2020

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 when i click on the file in excel?"

excel
Macros and VBA

1 Reply

  • Alan_Murray's avatar
    Alan_Murray
    MVP
    May 08, 2020

    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

Resources