/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 vote177 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote177 views1 answer
Excel vba center userform
VBA
0 vote177 views1 answer
Vba sheet visible
VBA
0 vote171 views1 answer
Vba text to general
VBA
0 vote168 views1 answer
Excel vba range contains
VBA
1 vote178 views1 answer
Vbs run
VBA
0 vote175 views1 answer
Reset border color textbox vba
VBA
0 vote194 views1 answer
Vbs exec hidden
VBA
4 votes173 views1 answer
Excel vba check cell not empty
VBA
0 vote164 views1 answer
Vb.net round to 2 decimal places
VBA