Excel Help please!! I need to find a way to link to a file whose path is listed in a spreadsheet cell?

I'm using a code to insert a file name of an external file into a cell in an Excel spreadsheet, and it works fine. What I would really like to do is make that file name a hyperlink to the file so I can click and open it. I've searched many sites and tried many things but I just can't get it to work... show more I'm using a code to insert a file name of an external file into
a cell in an Excel spreadsheet, and it works fine. What I would really like
to do is make that file name a hyperlink to the file so I can click and open
it. I've searched many sites and tried many things but I just can't get it to
work for me.

Or is there a way to import an image into a cell from an external folder, by looking up the file path that has been returned by a LOOKUP function?


Thanks for looking at my question.
4 answers 4