/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 vote193 views1 answer
Excel vba range contains
VBA
0 vote206 views1 answer
Excel vba ternary
VBA
0 vote231 views2 answers
S yyyy-MM-dd em vb net
VBA
3 votes187 views1 answer
Excel vba last row in range
VBA
0 vote202 views1 answer
How to add line graph vb net
VBA
0 vote201 views1 answer
Vba get application version
VBA
15 votes264 views2 answers
Xl vba dynamic string array
VBA
0 vote208 views1 answer
Excel named range sum
VBA
1 vote202 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote212 views1 answer
Vba first cell in range
VBA