Answers for "excel vba get folder of current workbook"

VBA
6

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
Posted by: Guest on March-30-2020
0

excel vba current folder

' Current folder
MsgBox ActiveWorkbook.Path      ' needs to be saved before
MsgBox CurDir					' default
Posted by: Guest on January-19-2021

Code answers related to "VBA"

Browse Popular Code Answers by Language