I was looking to create a hyperlink within excel that would open the folder where my current file is saved. I don't know where to begin, I found the question linked at the bottom and thought that would be a good start but I don't know how to trim the file name.
Linking to the saved files is easy enough when I working in a project (I use this template similar to One Note but with the excel calculation capabilities) but when I want to use my template for a new project I'd like the links to my source folders to transfer. I may not be explaining myself well.
If this is my current file: c:\desktop\homework\History\ClassCalendar.xlxs I would like the hyperlink to open the folder c:\desktop\homework\History, but if I changed where I save my document I'd like the hyperlink to change location too.
\..
, and pass that to aHYPERLINK
function?