/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

3 votes292 views1 answer
Extract the nth word from a text string
VBA
0 vote274 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote289 views1 answer
Excel vba protect content
VBA
0 vote270 views1 answer
Excel vba hide columns
VBA
0 vote309 views1 answer
Test if form is open vb
VBA
0 vote288 views1 answer
Vba len variant
VBA
0 vote380 views1 answer
Vba vbcrlf chr
VBA
0 vote280 views1 answer
Refresh token em vb net
VBA
0 vote279 views2 answers
Excel vba prevent save
VBA
0 vote312 views1 answer
Vba find last column in a row with data
VBA