Macro execution

[arkimp]

1.  I have created a standard macro which will be executed by other analytical app(which has country selection and file browse) .  If we don't select any file, macro should not be executed.  Can anyone help on this. 

2.  If there anyway we can stop macro execution  based on some condition (inside the Macro) ?

[IraWatt · Accepted solution]

Hey @arkimp,

Would a solution like this work for your first question:

Replace the brows with your macro. If the file brows has no data the container will close and the macro will not run. What kind of condition are you wanting to use to stop the macro internally? The test tool can be used to fire an error message based on certain conditions. 

[arkimp · Accepted solution]

I have 3 files (File browse ) connecting to macro.  If all the three selected , then only Macro container should be enabled.  How can we achieve this? 

[IraWatt · Accepted solution]

@arkimp you can use a formula like this:

IF length([#1])>0 AND length([#2])>0 AND length([#3])>0 THEN 'False' ELSE 'True' ENDIF

[arkimp · Accepted solution]

Some how this is not working.  I have connected three different action tool and it is working.  Thanks

[IraWatt · Accepted solution]

Nice one @arkimp, didn't know you could do that :) glad you got it working