Sign in to follow this  
Followers 0
Rob14

Newbie - want to automate data entry

3 posts in this topic

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

Share this post


Link to post
Share on other sites



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.


√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites

#3 ·  Posted (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 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.

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