/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 vote178 views1 answer
Vba foreach 2d array
VBA
0 vote149 views1 answer
Excel vba saveas no prompt for overwrite
VBA
1 vote144 views1 answer
Excel vba compare 2 rows
VBA
3 votes159 views1 answer
Vba post request json
VBA
0 vote156 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote154 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote152 views1 answer
Excel vba urlmon
VBA
0 vote147 views1 answer
Selecttoken em vbnet e json
VBA
25 votes282 views3 answers
String to date vb
VBA
8 votes266 views1 answer
Vba convert 2 bytes to an integer
VBA