Jump to content

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

Link to comment
Share on other sites

  • Moderators

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

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.
Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...