/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 vote207 views2 answers
Excel vba close without saving
VBA
0 vote219 views1 answer
Windows Presentation Foundation dark title bar
VBA
8 votes228 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote221 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote210 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote214 views1 answer
Vbs expand env var
VBA
0 vote211 views1 answer
Vb streamreader
VBA
1 vote225 views1 answer
Excel vba array remove first
VBA
5 votes228 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote234 views2 answers
Get unique random number in vb.net
VBA