Answers for "excel vba get the path of current workbook"

VBA
6

excel vba get the path of current workbook

'VBA function to retrieve this workbook's full path:

Function FullPath()
    With ThisWorkbook
        FullPath = .Path & Application.PathSeparator & .FullName
    End With
End Function

'--------------------------------------------------------------------

MsgBox FullPath
Posted by: Guest on March-30-2020

Code answers related to "VBA"

Browse Popular Code Answers by Language