/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 votes167 views2 answers
Vba active workbook path
VBA
1 vote151 views1 answer
Add a index column power bi
VBA
15 votes294 views2 answers
Xl vba dynamic string array
VBA
0 vote194 views1 answer
Vba userform textbox wrap text
VBA
0 vote152 views1 answer
Vbnet hex to binary
VBA
0 vote151 views1 answer
Vbnet get file name from path
VBA
0 vote144 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
3 votes163 views1 answer
Vba make long from two words
VBA
0 vote166 views1 answer
Sendkeys vba selenium
VBA
0 vote157 views1 answer
Make your computer talk vbscript
VBA