/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 vote296 views1 answer
Search in richtextbox vb.net
VBA
0 vote307 views1 answer
Vba compare strings
VBA
8 votes365 views1 answer
Excel vba determine number of elements in a 2D array
VBA
5 votes338 views1 answer
Excel vba low word from Long Integer
VBA
0 vote322 views1 answer
Vba find last column in a row with data
VBA
31 votes419 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote303 views2 answers
How to concatenate more than 40 lines in vba
VBA
-1 vote352 views1 answer
Vba sendkeys
VBA
0 vote284 views1 answer
Vbnet dynamically change excel sheet name
VBA
1 vote348 views1 answer
Perform http request in vb.net
VBA