Jump to content
Sign in to follow this  

Newbie - want to automate data entry

Recommended Posts

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.

"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!

Share this post

Link to post
Share on other sites

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



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  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...