Run excel Macro command in automation anywhere

DGUPTA9

New Member
Hi,

Please let me know , if Run excel macro commands returns the value. And if it does then help me in knowing that how it returns the value.

Thanks
 

VJR

Well-Known Member
Staff member
Hi DGUPTA9,

It doesn't appear that the Run Excel Macro command has a return value output parameter just like the Run Script command.
So may be you could try running the macro from a script file (like vbs) and see what happens.

An approach to this could be that you run the macro from AA and have the macro store the result in some far away hidden cell like Column Z and then read that cell from AA and get the result in a variable.
 

Kannan7

New Member
Using the "Run Excel macro" command, you can Run/ call Excel VBA macro from Automation anywhere. Please watch the below video for more details.
 
Top