/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 vote288 views1 answer
Excel vba existence of a file
VBA
0 vote292 views1 answer
Vba string start with
VBA
0 vote315 views1 answer
Excel vba chrw max value
VBA
1 vote298 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote307 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote325 views1 answer
Excel vba protect worksheet without password
VBA
1 vote307 views2 answers
Vba string to date
VBA
3 votes326 views1 answer
Vba make long from two words
VBA
0 vote313 views1 answer
VB get external IP address
VBA
0 vote327 views1 answer
Test if form is open vb
VBA