template "transfer from excel"

[redsammer]

I have a macro which enters 1 input into some software program. it works great. Now I want the input from an excel file and do more records.

I want the macro to run and dump each record from excel into the macro which places it in this software program.

Now I am coping the macro 5 times and entering the records manually. Then run the macro. This is sort of taking a lot of time.

I tried the template "transfer from excel" but how does it know the first row/column is in excel? Also there is not place to mention the macro? Just some macro hotkey.

Do you have a video to explain this? Or a sample ? Can I run with 2 inputs?

[forumsupport]

Hello,

If you want to transfer a column from an excel file to another application, you can create a task as follows:

1.) Open the Excel file and click the cell that you want to start copying from.
2.) Use 'Keystroke' command, CTRL+C to copy the first cell from excel, 'Down Arrow' key to go to next cell in column
3.) Similarly, CTRL+V to paste it into another application.
4) Use keystroke, 'Tab' to move the cursor to next field in another application.
5.) Save the macro.

Set repeat N times and run. It will copy data from Excel into another application. If you had 100 cells to copy, you can copy this way by setting 100 repeat.

Alternatively, try using our advanced automation product, Automation Anywhere 5.5.1 that provides Excel command that works tightly with excel to perform routine functions like Go To cell, get cells, run excel macro etc. You can use ‘Excel-Open Spreadsheet’ command to open the excel spreadsheet in which want to entered the data, ‘Excel-Go to Cell’ command to go to the particular cell in the spreadsheet and use the ‘Excel-Get Cells’ feature to extract the data in spreadsheet.

You can view demo on Excel commands usage from, http://www.tethyssolutions.com/AAExcelIntegration.html

You can download free trial version of Automation Anywhere 5.5.1 from our website:
Automation Anywhere - The Automation Software. Automate & Schedule IT & Business processes easily.

Hope that helps.