IF THEN application

[dilip]

i have excel sheet in which "IF" logical function is used which denotes true or false value in textual form.Can i do the task such that on realizing resulted value in excel cell,perform a task in another application in either one of the two ways .i.e. one task for true or another task for false. If yes, can plz someone provide me task action sample?
thank u

[forumsupport]

Hello Dilip,

You can certainly automate mentioned task using Automation Anywhere. For your reference, we have attached a sample. Please copy .atmn files under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder. Copy Book1.xls under C:\.

A1 cell in Book1.xls have a 'If' function that validates if value in cell B1 is greater than C1. Based on 'True' or 'False' result it calls respective task. Instead of calling a task you can also directly insert the command actions that you want to perform for specific condition.

This task will first set B1>C1 and will call SubTask_True.atm. After that, it will set C1>B1 and will call SubTask_False.atmn.

To get started easily, you can view the demo on Automation Anywhere 5.0 usage, at http://www.tethyssolutions.com/automation-tutorials.htm

In addition, there are many online sample tasks available at http://www.tethyssolutions.com/automation-samples.htm

We also have a manual for Automation Anywhere 5.0. For that, please refer the AAUserManual.pdf link given below:
http://www.tethyssolutions.com/Downl...UserManual.pdf

Hope that helps.