/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
Vba extract filename from path
VBA
0 vote168 views1 answer
Vbs
VBA
1 vote160 views1 answer
Vba delete array element
VBA
0 vote167 views1 answer
Excel vba existence of a file
VBA
0 vote166 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote187 views1 answer
Delete all controls in an area vb
VBA
0 vote163 views1 answer
Excel vba disable alerts
VBA
0 vote161 views1 answer
Vb get ip address
VBA
1 vote171 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote169 views1 answer
Excel vba assign shortcut key to button
VBA