I currently use this solution via VBA:
Sub Test()
MsgBox (FullNameExcel)
End Sub
Function FullNameExcel()
FullNameExcel = CreateObject("Scripting.FileSystemObject").GetAbsolutePathName(ThisWorkbook.Name)
End Function
credits to: @Robert here on stackoverflow
I am using this option since the function created by
guwidoe named GetLocalOneDrivePath which is on github stopped working for me, does anyone else use this solution or have any other suggestions besides the ones below?
crash, not works for me:
https://gist.github.com/guwidoe/038398b6be1b16c458365716a921814d
adds bars that do not exist in the Excel address:
https://learn.microsoft.com/en-us/archive/msdn-technet-forums/1331519b-1dd1-4aa0-8f4f-0453e1647f57
New contributor
Adriano Marques is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.