/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 vote213 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote218 views1 answer
Vba parameter adodb null value
VBA
0 vote217 views1 answer
Vba border weight
VBA
1 vote260 views1 answer
Vba format string as cash
VBA
1 vote212 views2 answers
Get all column names from excel vba
VBA
1 vote212 views1 answer
Vba compile error object required
VBA
0 vote227 views1 answer
Average vba
VBA
1 vote234 views1 answer
Excel vba force recalculation
VBA
1 vote220 views1 answer
Highlight selected cell in excel vba
VBA
0 vote236 views1 answer
Excel last used row
VBA