Need help with a fairly complex script

[Larsen8040]

I have a need for a certain script for work. I just started working with autoit, but im far from figuring out what I need to learn to accomplish my task. Id like to break it into pieces and figure it out as I go with some help.

I will need autoit to use Internet explorer and a proprietary application.

Part1

I need to read information from excel. Colum A would be an account number, and Colum B would be a Social Security Number. Depending on how many accounts I have will determine how many rows are used, but it can vary from 10-10,000

The cells will be populated with out autoit.

Once I populate the spreadsheet I need a script to read the SSN in colum B and paste it into a search field on a skip tracing website and then click search. Once the search completes I have to copy and paste the returned results into another application. and then start another search on the next SSN in Colum B, rinse and repeat, until colum A and B are empty.

There is a lot more to the end result, but This is the part im having the most trouble with. Any help is appreciated. Thanks!

[Guest]

Welcome Larsen8040,

This is not a General Help and Support forum, please request the Mod to move to the help section.

[hannes08]

Hello Larsen, for reading and writing to Excel Spreadsheets have a look at the _Excel*() functions.

Especially look at _ExcelReadSheetToArray().