Tag Archives: CurrentPath

No Thumbnail

Word VBA, Get Current File Path and Name

In this article I will explain how you can get the current path and name of the word document you are working with. – File Path: The file path can be obtained using the code below: Dim strPath As String strPath = ThisDocument.FullName MsgBox (strPath) Result: Note:

No Thumbnail

Excel VBA, Get Current File Path and Name

In this article I will explain how you can get the current path and name of the file you are working with. – File Path: The file path can be obtained using the code below: Dim strPath As String strPath = ThisWorkbook.FullName MsgBox (strPath) Result: Note: