/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 vote171 views1 answer
Excel text to columns line break
VBA
5 votes206 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote192 views1 answer
For each item in folder outlook vba
VBA
0 vote253 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote170 views1 answer
Excel vba disable copy paste
VBA
0 vote192 views1 answer
Excel vba formatconditions positive
VBA
0 vote168 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote196 views1 answer
Vbscript Trim
VBA
0 vote179 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote168 views1 answer
Vba first cell in range
VBA