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.
VBA Path Application Property – Syntax
Here syntax for Path Property of application object in VBA.
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
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
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.