/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

0 vote270 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote299 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
31 votes380 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote291 views1 answer
How to mount floppy disks in vb.net
VBA
3 votes274 views2 answers
Excel "vba" match last value
VBA
0 vote318 views1 answer
Filesystemobject vba reference
VBA
0 vote265 views1 answer
How to use VBA to add new record in MS Access?
VBA
5 votes335 views1 answer
Vba low byte from INTEGER
VBA
0 vote288 views1 answer
Vbs exec hidden
VBA
0 vote266 views1 answer
Vbnet get file name from path
VBA