/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 vote366 views1 answer
Wpf dark title bar
VBA
0 vote295 views1 answer
Vb ternary
VBA
0 vote330 views1 answer
Visual basic cmd
VBA
1 vote235 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote262 views1 answer
Create new worksheet excel visual basic
VBA
0 vote307 views1 answer
Vbnet check if string is only letters
VBA
0 vote416 views1 answer
Vba array of integers
VBA
0 vote279 views1 answer
Vba type variable
VBA
2 votes287 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote289 views1 answer
VBA Loop to range
VBA