/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 vote178 views1 answer
Vba len variant
VBA
8 votes267 views1 answer
Vba make integer
VBA
0 vote195 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote199 views1 answer
.net crash app
VBA
2 votes137 views2 answers
Vba exit loop
VBA
0 vote209 views1 answer
Excel vba protect shapes
VBA
6 votes191 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote185 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote194 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote187 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA