This video explains about execute macro activity . I have explained the basic features in before before video.This is other options available as part of the execute macro activity.
Below scenario's explained in the video:
Scenario:1
Step1: Create macro with parameters
Step2: Give the parameters dynamically from ui path to the excel sheet
Step3: Display the result
scenario :2
Step1 : Create a function that returns a value
Step2: get the returned value from excel to ui path
Step3: display the value