I'm looking for a function like =Now() which returns date/time into a cell. Same idea but I want as return the path and the file name like this: \\evofiles\jg library\12-Quality\2-Internal\3-Projects\Document Registration\Document_Registration_DRAFT.xlsm
Is there a ready command? Could such command be added as add in or macro?
As alternative variant but not as good would be just a macro which I can add to my quick access toolbar then..