Path Property of Application Object VBA

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.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


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.

LIMITED TIME OFFER

Leave A Comment


Related pages


delete filtered rows in excelexcel remove duplicate cellsexcel formula in vba codemacro excel programmingoffset vbamonthly planning calendar template excellookup function excelinstr vba excelexcel find duplicates and deletehow to write a excel macroremove dupes in exceladding lines to excel spreadsheetrange command vbavba open dialog boxswitch case vbatrim formula in excelrange in excel macromove worksheet to another workbooksyntax for sql commandsifs statement excelproject portfolio management excel templatesample vba code for excelhlookup functionvba sumifs exampletrend analysis chart in excelexcel programmer salaryvb6 open text filevba what is dimdeveloper tab excel 2007copy a worksheet in excellookup value excelhow to add data validation in excelrun a query in access vbaenable macro vbahow to combine multiple excel sheets into onevba rowcountword vba message boxif statements in excel 2010vba rowcountexcel delete extra rowsvba merge cellsexcel append tablescombo box in visual basicms access adodb connectionexcel macro tutorial pdfexcel short cut keyquery excel with sqlhow to use sumif in excelselect sheet vbahow to do hlookup in excelexcel multiple if conditionsvlookup left to rightvba excel isblankestimation template for software developmentaccess 2013 msgboxcool excel spreadsheetshow to use sumif functionpassword protected spreadsheetvbe excelwhat is operator and operandhow to create a userform in excel 2010advance filter excelunhide top rows in excelvba left stringwhat is v lookup in excelhighlight column excelmerge rows excelpivot table descending orderexcel vba eventsselect case statement vbaexcel vba cells rangebeginner excelvba color codeshow to create excel macroprotect sheet excel vbaexcel codes and formulas