/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

2 votes156 views1 answer
Excel vba date to string conversion
VBA
1 vote157 views2 answers
Vba string length
VBA
12 votes276 views1 answer
Excel vba write string to text file
VBA
5 votes160 views1 answer
Excel vba left word from Long Integer
VBA
8 votes200 views1 answer
Excel vba make word
VBA
0 vote145 views1 answer
Vba check 32 or 64 bit
VBA
0 vote165 views1 answer
Excel vba open browser
VBA
5 votes150 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote152 views1 answer
Excel vba protect sheet
VBA
0 vote150 views1 answer
Get month number from month name vbnet
VBA