/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 votes307 views1 answer
Excel vba date to string conversion
VBA
0 vote294 views1 answer
Vba apostrophe chr
VBA
2 votes331 views1 answer
Vba file from path
VBA
0 vote301 views1 answer
Vlookup columns not next to each other
VBA
0 vote317 views1 answer
Make all controls in an area not visable vb
VBA
0 vote387 views2 answers
Excel vba store array and write to sheet
VBA
0 vote337 views1 answer
Set datetimepicker value to null vb
VBA
0 vote320 views1 answer
Vba get relative cell address
VBA
1 vote307 views1 answer
Excel date to unix timestamp
VBA
0 vote338 views1 answer
Excel vba protect shapes
VBA