Path Application Property in VBA is used to get the complete path to the application or workbook. It excludes the final separator and name of the application. Please find the more details about path property of application object in the following section.

Excel VBA Path Application Property Object

VBA Path Application Property – Syntax

Here syntax for Path Property of application object in VBA.

Application.Path

Where Path as String.
In the above syntax Application represents object and Path is the Property of Application object.

VBA Path Application Property: Example 1

Please find the below example for Path Property of application object in excel VBA. The below example displays the complete path of the application in Excel window.

Sub Appl_Path()
'Path is the property of application object
MsgBox "The application path is :" & Application.Path
End Sub

Output:

The application path is :C:\Test

VBA Path Application Property: Example 2

Please find the below example it will give the complete path of the workbook or application.

Sub WrkBk_FulPath()
'Path is the property of application object
MsgBox "Workbook full path is :" & ThisWorkbook.FullName
End Sub

Output:

Workbook full path is : C:\Test\MyFile.xlsm

VBA Path Application Property – Instructions

Please follow the below steps to execute the VBA code to save the excel file.
Step 1: Open any existing Excel Application.
Step 2: Press Alt+F11 – This will open the VBA Editor.
Step 3: Insert a code module from then insert menu.
Step 4: Copy the above code and paste in the code module which have inserted in the above step.
Step 5: Now press F5 to execute the code.
Step 6: The above macro or code displays the application path in the message box window.

Hey! Join Our Community

Get Quick Responses & Experts' Answers in Minutes!
Get Notified - When Answered Your Question!