The Excel can contain macros which need be run to get the necessary result.
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.
Related Topics