Run Method of Application Object VBA

Run Application Method in VBA is used to runs a procedure or function which is written in Visual Basic Application. Please find the syntax and remarks of Run Application Method in VBA.

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 Run Application Method – Syntax

Here syntax for Run method of application object in VBA.

Application.Run(

[Macro], [Arg1], [Arg2],…, [Arg30])

Where
Macro: It is an Optional parameter. It is used to run the macro.
Arg1 to Arg30: It is an Optional parameter. It is used to passed to the function.
In the above syntax Application represents object and Run is the method of Application.

VBA Run Application Method: Example 1

Please find the below example for Run method of application object in excel VBA.

Sub Appl_Run()
Application.Run "'Workbook1.xls'!MyMacro"
End Sub

VBA Run Application Method: Remarks

Please find the below remarks of Run method of application object in excel VBA.
• We cannot use named parameters in this method.
• We cannot pass objects as parameter to procedures by using run method.

VBA Run Application Method – 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.

LIMITED TIME OFFER

Leave A Comment


Related pages


definition of excel formulasexcel activeworkbook saveasis empty vbaexcel formulas with examples in excel sheet vlookupexcel vba vlookupvba templatesdashboard widgets for excelvba examlooping in vbaexcel template gantt chartwhat is hlookup in excel with examplevba lessonsvba dashboarddocmd.runsql deletecreating dashboards in excelhow to do a pivot table in excel 2013word template agendaiserrorvba sort arrayhow do you delete rows in excelunprotect spreadsheetvba combobox multiple selectionhow to insert a pivot table in excel 2013practice excel tests for interviewssumif exelexcel vba multiple ifexcel chart bar widthhide macros in excelexcel how to remove blank rowssumif excel 2010 examplevba run subvba calling a subsort excel spreadsheetuserforms in excel 2010while loop vbavlookup formula in excel 2007 with exampledml & ddlhow to combine duplicate rows in excelhlookup excel 2010 exampleexcel insert row formulaplanning schedule template excelpassword sheet excelexcel vba msgbox custom buttonsoutlook vba examplesexcel bubble chart templateaddress vbaexcel formulas with examplerecordset getrows vbadefinition of charts in excelhow to get developer tab in excelproject charter sample templatevba scriptsexcel vba copy sheet to endhow to use countif formula in excel 2007excel formulas valuevba word application objectsql server pivot table examplevlookup using two criteriaunhide sheets in excel 2007excel vba loop through sheetscell vbaexcel auto enable macrosinsert function vbaformula for hlookupactivesheet rangelock excel worksheetvba coding tutorialremove doubles in excelvb color indexexcel formula explanationsvba excel unmerge cellscopy excel sheet to another filevisual basics in excelexcel macro exercisesmicrosoft access remove duplicatessas stands forexcel 2007 concatenateremove protection from excel 2010 without passwordcheck activexexcel macro paste valuesvb clear listbox