/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 vote216 views1 answer
Type excel.application is not defined vb
VBA
31 votes520 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote243 views1 answer
Visual stuiod not recognising desgined labels
VBA
1 vote228 views1 answer
Excel vba autofit
VBA
0 vote242 views1 answer
Vba search string position
VBA
0 vote234 views1 answer
Excel last used row
VBA
0 vote209 views1 answer
Excel vba concatenate range
VBA
0 vote217 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
8 votes318 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote223 views1 answer
Remove last 8 characters from string vb
VBA