/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 vote353 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote333 views1 answer
Remove frist letter from string vbnet
VBA
0 vote370 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote320 views1 answer
Open application from vbnet
VBA
0 vote313 views1 answer
Excel vba hide columns
VBA
0 vote349 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
4 votes353 views2 answers
Vba last row
VBA
0 vote335 views1 answer
Vbnet line graph smooth lines
VBA
5 votes348 views1 answer
Xl vba double quotes in string literal
VBA
3 votes368 views1 answer
Vba post request json
VBA