/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

0 vote353 views1 answer
Vba integer to double
VBA
1 vote320 views1 answer
Excel vba make cell visible
VBA
22 votes547 views1 answer
Xl vba check for folder
VBA
0 vote330 views1 answer
Select case vba
VBA
0 vote322 views1 answer
Vb net check if file exists
VBA
0 vote377 views1 answer
Excel vba protect scenarios
VBA
0 vote348 views1 answer
Prive sub enter clicked vb
VBA
8 votes423 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote341 views1 answer
Add text to combobox drop down vb
VBA
1 vote347 views1 answer
Vba loop through files in folder
VBA