/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

8 votes238 views1 answer
Excel vba make integer
VBA
31 votes507 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote254 views1 answer
Vba extract filename from path
VBA
0 vote231 views1 answer
Excel last used row
VBA
1 vote211 views2 answers
Vba function return array
VBA
8 votes237 views1 answer
Run command pormpt in background windows
VBA
2 votes211 views1 answer
Excel vba date to string conversion
VBA
3 votes234 views1 answer
Vba post request json
VBA
0 vote230 views1 answer
Excel vba open browser
VBA
0 vote226 views1 answer
Vb run command
VBA