Question : excel vba get the workbook full file name with path
Answered by : daniel-ferry
MsgBox ThisWorkbook.FullName
Source : http://academy.excelhero.com/ | Last Update : Sat, 11 Apr 20
Question : vba active workbook path
Answered by : vastemonde
Application.ActiveWorkbook.Path ' just the path itself (directory)
Application.ActiveWorkbook.FullName ' path with the workbook name.
Source : | Last Update : Sun, 07 Feb 21