/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 vote363 views1 answer
Vba line feed
VBA
0 vote236 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote255 views1 answer
Excel filter by date not working vba
VBA
1 vote239 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
2 votes223 views1 answer
Vba uppercase first letter of each word
VBA
0 vote241 views1 answer
Pivot data source not accepting table named range vba
VBA
31 votes532 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote249 views1 answer
Excel vba convert cells address
VBA
0 vote239 views1 answer
Excel vba delete folder
VBA
0 vote241 views1 answer
Excel vba extract year
VBA