/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 vote173 views1 answer
Prive sub enter clicked vb
VBA
0 vote170 views1 answer
Vba range clear formatting
VBA
0 vote174 views1 answer
Vba listbox remove all items
VBA
0 vote211 views1 answer
Vba excel parser xml
VBA
1 vote172 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote181 views1 answer
Find if year is leap year vb
VBA
0 vote161 views1 answer
Vba get workbook name
VBA
0 vote173 views1 answer
Open file dialog in vb.net
VBA
0 vote211 views1 answer
Excel vba delete columns in range
VBA
0 vote177 views1 answer
Excel vba textbox forecolor disabled
VBA