/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 vote237 views1 answer
Vba listbox remove all items
VBA
0 vote240 views1 answer
Excel vba first working day month
VBA
3 votes247 views1 answer
Excel insert blank row for value change in column
VBA
0 vote230 views1 answer
Vba apostrophe chr
VBA
2 votes241 views1 answer
Vba file from path
VBA
0 vote223 views1 answer
Vba run command
VBA
1 vote229 views1 answer
Vba refresh pivot table
VBA
0 vote226 views2 answers
Excel vba close without saving
VBA
0 vote220 views1 answer
Excel vba center userform
VBA
1 vote237 views1 answer
Excel vba get column number from column name
VBA