Larsen8040 Posted February 7, 2012 Share Posted February 7, 2012 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! Link to comment Share on other sites More sharing options...
Guest Posted February 7, 2012 Share Posted February 7, 2012 Welcome Larsen8040, This is not a General Help and Support forum, please request the Mod to move to the help section. Link to comment Share on other sites More sharing options...
hannes08 Posted February 7, 2012 Share Posted February 7, 2012 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] Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now