/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

5 votes165 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote192 views1 answer
Excel vba protect content
VBA
1 vote156 views1 answer
Vba loop through files in folder
VBA
1 vote134 views1 answer
Vba delete file
VBA
0 vote146 views1 answer
Vba loop through textboxes
VBA
0 vote148 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote140 views1 answer
Internet explorer reference vba
VBA
0 vote134 views1 answer
Change whcih control a user has selected vb
VBA
0 vote133 views1 answer
How to format a textbox as date vb net
VBA
0 vote140 views1 answer
Select case vba
VBA