/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 vote256 views1 answer
Vba boolean to string
VBA
0 vote227 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote251 views1 answer
How to mount floppy disks in vb.net
VBA
5 votes249 views1 answer
Excel vba second byte from INTEGER
VBA
5 votes263 views1 answer
Vba low byte from INTEGER
VBA
3 votes233 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote251 views1 answer
Excel vba protect sheet
VBA
0 vote243 views1 answer
How to format a textbox as date vb net
VBA
0 vote238 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote229 views1 answer
Vba string start with
VBA