/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 vote115 views1 answer
Enter into cells data grid view
VBA
0 vote157 views2 answers
VB
VBA
0 vote120 views1 answer
Excel vba formatconditions range
VBA
2 votes126 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote126 views1 answer
Change form background image vb
VBA
0 vote121 views1 answer
Vbnet get file name from path
VBA
0 vote118 views1 answer
Excel vba center userform
VBA
0 vote128 views1 answer
Vbscript Trim
VBA
9 votes246 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote109 views1 answer
Vba argument is set
VBA