Automation Anywhere - The Automation Software

Sample Tasks -> T34- Leverage functionality of other applications with Automation Anywhere to automate your task

Task Description: You can easily leverage functionality of other applications to automate your task. Lets say you are using a CAD package or a financial software and you want to leverage functions provided by that software along with Automation Anywhere to automate your tasks. You can do that.

The following example uses LEN function from Excel to calculate length of filename for each file. See how Automation Anywhere and Excel can be used together.

T34.atmn

Note: Save the .atmn file in My Documents->Automation Anywhere->Automation Anywhere->My Tasks

Solution
1.	Create new task	Click on Tools->Task Editor
2.	Loop through all files in a folder using Automation Anywhere	In Editor, from the Loop category select the Start Loop command Select the option 'Each file in a folder' Select the folder from where you want to find the length of the filenames. Screenshot 1
3.	Find the length of filename using Excel	Insert Keystroke command in Excel window to use the LEN function to find the length of the filename. $FileName$ is the system variable that will have the name of the file within the loop. For every iteration of the loop, it will have the next value of the file in the folder. Screenshot 2
4.	Print the length of the filename in Notepad	Copy the length of the filename from the Excel window and paste it in a notepad window. Screenshot 3

When you run this task, it loops through all the files from folder and calculates the length of all the files and prints them in a notepad window.