Sign in to follow this  
Followers 0
Larsen8040

Need help with a fairly complex script

3 posts in this topic

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!

Share this post


Link to post
Share on other sites



Welcome Larsen8040,

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

Share this post


Link to post
Share on other sites

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

Especially look at _ExcelReadSheetToArray().


Regards,Hannes[spoiler]If you can't convince them, confuse them![/spoiler]

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0