/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

2 votes131 views1 answer
Date format for ms chart vb.net
VBA
0 vote146 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote147 views2 answers
Excel vba protect cells with formula
VBA
0 vote132 views1 answer
Excel vba chrw max value
VBA
8 votes128 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote148 views1 answer
Vbs run with cscript
VBA
1 vote136 views1 answer
Random number generator vb.net
VBA
0 vote149 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote141 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote133 views1 answer
Openfiledialog specific folder
VBA