Excel Run Macro

<< Click to Display Table of Contents >>

Navigation:  Actions > Excel >

Excel Run Macro

The Excel can contain macros which need be run to get the necessary result.

ExcelRunMacro

 

Macro Name

Specify the name of the macro which is necessary to run. You can use variables.

For example:

TestMacro

 

The macro name can be specified using the document name.

For example:

Book1.xlsm!TestMacro

 

If you need to pass some parameters use such expressions

'TestMacro "Hello World!"'

or

'TestMacro("Hello World!")'

 

If you need to pass some cell value to the macros use Evaluate function with cell address.

For example:

'TestMacro(evaluate("$A$1"))'

or

'TestMacro evaluate("$A$1")'

 

Read more detail explanation here.

 

 

note Related Topics

Excel Open Document

Excel Get Cells

Excel Set Cells

Excel Cell Format

Excel Save Document

Excel Save As

Excel Close