/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 vote160 views1 answer
Vba parameter adodb null value
VBA
1 vote167 views1 answer
Set font for ms chart vb.net
VBA
0 vote207 views1 answer
Vba excel do not recalculate before save
VBA
0 vote154 views1 answer
Enter into cells data grid view
VBA
0 vote165 views1 answer
Vba sort the data Z to A
VBA
25 votes309 views3 answers
String to date vb
VBA
0 vote156 views1 answer
Hello world vb.net
VBA
5 votes188 views1 answer
Excel vba get user selected range
VBA
0 vote159 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote149 views2 answers
Excel vba prevent save
VBA