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


write an excel macroexcel sort ascendingexcel 2010 remove duplicate rowscreate macros excelexcel array tutorialproject plan timeline template excelunlock an excel fileunlock excel filevba istextaccess vba run sqlvba database connection examplebest excel dashboard examplesactiveworkbookexcel delete multiple rowsexcel vba thisworkbookhow to activate macros in excel 2007excel merge cells formuladelete range vbaexcel formula for cell colorpivot table meaningmerging rows in excelexcel vba boxexcel example formulasend loop vbaexcel macro copy row to another sheetwhile loop vbadatediff excelluseful vba functionsexcel spreadsheet dashboard templatesexcel concatinationadodb recordset vba excelvisual basic sample codes for beginnersvb scripting interview questions and answersshort cut keys excelcase excel vbaexcel macro functionshort cut key of excelgoto excel vbatimeline template in excelpivot table in excel 2007 with example xlssum if functionproject reporting template excelvba color codesexcel vba read filecountif formula excel 2007vb code for excelvba message box codevba open access database from excelmsg box vbaexcel vba copy range to another sheetexcel line graph tutorialvlookup macro excellearn vba programmingworkbooks activatevba macro recorderexcel how to hide columnsvba coding for dummiesexcel 2007 autosaveexcel averageifscreate checkbox in excel 2010freshers interview questions and answersyes no vbahow to dedupe a list in excelaccess vba delete tablemicrosoft excel check boxexcel vba example codeshortcut key insert row excelactivex vbamulti select listboxprogrammer analyst interview questions and answersdefine worksheet in excelexcel meeting templateexcel unlock password protected sheetlearn vba coding