/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 vote244 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote255 views1 answer
Vba character ascii code
VBA
20 votes556 views1 answer
Excel vba factorial
VBA
0 vote258 views1 answer
Columns dont autoresize on program start vb.net
VBA
4 votes237 views1 answer
Excel vba how to reset usedrange
VBA
0 vote242 views1 answer
Vba pass named range to function
VBA
0 vote261 views1 answer
Build an index all files of a FTP site
VBA
2 votes249 views1 answer
Vba file from path
VBA
-1 vote230 views1 answer
Vba code to add new column in table
VBA
0 vote223 views1 answer
Do until vb.net
VBA