/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 vote440 views1 answer
Visual basic cmd
VBA
0 vote345 views1 answer
Change "location" of binding navigator vb
VBA
0 vote385 views1 answer
Make your computer talk vbscript
VBA
0 vote384 views1 answer
Vbnet cycle through charaters in string
VBA
1 vote367 views1 answer
Excel vba last column in range
VBA
0 vote368 views1 answer
Vba open report
VBA
0 vote359 views1 answer
Not allow form to be resized
VBA
0 vote383 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote382 views2 answers
VB
VBA
0 vote345 views1 answer
Discern between file and folder given path vb.net
VBA