/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

1 vote194 views1 answer
Extract the second word in a text in excel
VBA
0 vote177 views1 answer
Vba get text file content
VBA
1 vote150 views1 answer
How to open cmd with vbd
VBA
-1 vote174 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote191 views1 answer
Excel vba ternary
VBA
1 vote190 views1 answer
Excel date to unix timestamp
VBA
0 vote220 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
1 vote200 views1 answer
Vba loop through files in folder
VBA
0 vote185 views1 answer
Vbnet line graph smooth lines
VBA
0 vote185 views2 answers
Do until loop vba
VBA