Hyper link to file location

BrachChad

New Member
Joined
Apr 24, 2019
Messages
4
How do I write a formula to insert a hyperlink to the folder that the file is in, and still show the full path name?
 

BrachChad

New Member
Joined
Apr 24, 2019
Messages
4
I am also having trouble with a formula to show the full path and file name.

=cell("filename") returns the file path correctly but returns the file name like this:

[quote45676.xlsm]quote

I need to just be quote45676???

Any ideas would be greatly appreciated.

Thx
Chad
 

Forum statistics

Threads
1,078,338
Messages
5,339,638
Members
399,317
Latest member
mLife

Some videos you may like

This Week's Hot Topics

Top