/VBA/Excel vba get the path of current workbook

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

Source: academy.excelhero.com

Similar codes

-1 vote122 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote129 views1 answer
Delete all controls in an area vb
VBA
0 vote125 views1 answer
Vbscript for loop
VBA
0 vote120 views1 answer
Thread sleep vb
VBA
0 vote122 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote112 views1 answer
Excel vba milliseconds
VBA
0 vote137 views1 answer
Vba parameter adodb null value
VBA
1 vote126 views1 answer
Excel vba force recalculation
VBA
0 vote121 views1 answer
Telephon call in vba
VBA
1 vote133 views1 answer
Excel vba array remove first
VBA