/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 vote379 views1 answer
Loop through lines in text file vb net
VBA
0 vote369 views1 answer
How to format a textbox as date vb net
VBA
0 vote365 views1 answer
Average vba
VBA
0 vote347 views1 answer
Vba border weight
VBA
8 votes392 views1 answer
Excel vba determine number of elements in a 1D array
VBA
8 votes452 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote357 views1 answer
Openfiledialog specific folder
VBA
1 vote328 views1 answer
Excel vba hide zero values
VBA
5 votes427 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote375 views1 answer
Vba registry settings
VBA