/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 vote176 views1 answer
Average vba
VBA
1 vote173 views1 answer
How to put a gridpain in a vbox
VBA
0 vote182 views1 answer
Excel vba unmerge sheet
VBA
5 votes186 views1 answer
Excel vba low byte from INTEGER
VBA
1 vote178 views1 answer
Vbscript convert ascii code to character
VBA
0 vote177 views1 answer
Vba collection key list
VBA
0 vote177 views1 answer
Rotate image by any angle vb.net
VBA
0 vote187 views1 answer
Thread sleep vb
VBA
1 vote117 views1 answer
Ms access open form to new record
VBA
0 vote167 views1 answer
How to use VBA to add new record in MS Access?
VBA