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


clear duplicates in excelproject plan template excel 2007excel hyperlink macroexcel remove empty rowsvba excel leftsum offset excelvba msgbox next linevba byrefdeduplicate excelcountif function excelexcel project management tracking templatesvba new workbookoutlook macro examplesexcel checklist templatesvba connection string sql serverfix excel rowprint macro excelexcel vba string containshow to unhide columns in excel 2013excel offset functionwhat is vlookup formulahow to duplicate a row in excelsample xlsm file downloadisnumber excelvba onclickcode execution has been interrupted excel vbavba code dimhow to combine data from multiple worksheets in excel 2010vba macro excel examplesexcel vba vbyesnomultiple if statement in excelsql excel tablealphabetical order in excel 2007delete columns vbahow to unprotect a password protected excel sheetrca format in wordhow to combine duplicate rows in excelcombine multiple worksheets into onesumif function examplesadvanced excel formulas with examples in excel sheetexcel if statement with two conditionsvbscript filecopyvlookup definationsave macro in excelms access vba open formmessagebox usingexcel worksheet exampleshow to hide cells in excellhow to add drop down list in excel 2007vba offsetexcel 2010 unhide rowsistext excelexcel activeworkbookcol_index_num vlookupmsgbox function in vbscriptexcel averageifhow to consolidate excel filesaccess vba on errorexcel 2010 userform templatesclient tracking excel templateproject dashboard ppthow can i unprotect an excel sheet without the passwordwhat are dml statementsmsgbox icondrop down tabs in excelvba msgbox inputcopy paste vbavba beginnerhow to write vba code in excel 2010vba matchhyperlink to excel worksheetexcel formula trimvba excel code listexcel macro autofiltermacro to remove duplicatesexcel shortcut charthow can i unhide columns in excel