/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 vote296 views1 answer
Test if form is open vb
VBA
0 vote286 views1 answer
Vba round to 2 decimals
VBA
0 vote286 views1 answer
Vbnet cycle through charaters in string
VBA
-1 vote293 views1 answer
How save excel through visual basic
VBA
0 vote269 views1 answer
Vbscript abs
VBA
4 votes280 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote267 views1 answer
Vba word pdf table to excel
VBA
0 vote285 views1 answer
Excel vba first working day month
VBA
1 vote286 views1 answer
Set font for ms chart vb.net
VBA
0 vote277 views1 answer
Vba copy file
VBA