/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 vote338 views1 answer
Excel vba join variant array
VBA
4 votes354 views2 answers
Vba last row
VBA
0 vote329 views1 answer
Find days in month vba
VBA
0 vote327 views1 answer
Excel vba center userform
VBA
0 vote494 views1 answer
Amd64 vs arm64 linux
VBA
1 vote341 views1 answer
Vbs run
VBA
0 vote345 views1 answer
Convert number to minutes in vba
VBA
0 vote374 views1 answer
Excel vba unlock sheet without password
VBA
0 vote388 views1 answer
Vbs run with cscript
VBA
0 vote340 views1 answer
How to use if condition in time vba
VBA