/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 vote231 views1 answer
Vba dictionary length
VBA
0 vote203 views1 answer
VBA Sleep Snippet
VBA
0 vote244 views1 answer
Vbnet add axis labels to chart
VBA
0 vote204 views1 answer
Excel vba chrw max value
VBA
0 vote238 views1 answer
Vba cell all borders
VBA
2 votes150 views2 answers
Vba exit loop
VBA
4 votes207 views1 answer
Vba create directory
VBA
3 votes212 views1 answer
Vba double quote
VBA
0 vote202 views1 answer
Vbscript abs
VBA
3 votes209 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA