Question : excel vba get the path of current workbook
Answered by : daniel-ferry
'VBA function to retrieve this workbook's full path:
Function FullPath() With ThisWorkbook FullPath = .Path & Application.PathSeparator & .FullName End With
End Function
'--------------------------------------------------------------------
MsgBox FullPath
Source : http://academy.excelhero.com/ | Last Update : Mon, 06 Apr 20