Rob14 Posted June 20, 2014 Share Posted June 20, 2014 Is AutoIt the best approach for trying to automate the input of names and addresses into the data entry screen of a new program? Just started evaluating AutoIt and have tried the Autoit123 demo, but it seems geared to creating Gui interface and so forth. I need to navigate the data entry fields of one program, and switch back and forth to Excel copying a couple of data fields into the data entry screen, clicking "Create", and then creating a New account in one program and scrolling down to the next line in Excel. Is there a way to navigate cells knowing which you are on? Is there an example script for this sort of thing? Any suggestions welcome, including If someone thinks another utility would be easier. Thank you Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted June 20, 2014 Moderators Share Posted June 20, 2014 Hi. Rob14, welcome to the forum. Yes, AutoIt can do what you're looking to accomplish. If you search the help file, you'll find a number of Excel functions that can assist you in easily reading/writing data to and from a workbook. "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
jdelaney Posted June 20, 2014 Share Posted June 20, 2014 (edited) The below functions are good places to start...they are links, with examples: ; excel part:...this one has the basics of what you need, and how to initiate it _ExcelReadSheetToArray WinGetHandle WinActivate ControlFocus ControlGetHandle ControlSetText ControlClick Then, you just need practice with looping through arrays Edited June 20, 2014 by jdelaney IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window. 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