/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

1 vote245 views1 answer
Vbs run
VBA
0 vote252 views1 answer
How to add line graph vb net
VBA
0 vote230 views1 answer
Excel vba disable alerts
VBA
0 vote234 views1 answer
Remove first character from string vb
VBA
0 vote238 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote247 views1 answer
How to set location and size of new from vb
VBA
0 vote237 views1 answer
Internet explorer reference vba
VBA
1 vote247 views1 answer
Vba refresh pivot table
VBA
20 votes311 views1 answer
Excel vba recursive example factorial function
VBA
0 vote237 views1 answer
Excel vba range contains
VBA