koushik6685 Posted November 25, 2011 Share Posted November 25, 2011 Hi All,I'm new to AutoIt scripting. I've posted my sample code below for simple save. Now i want to automate using excel. I have marked the place as bold to where to occur. Kindly let me know how i can proceed.Run("C:\Users\User\AppData\Local\Apps\4.0\45P9YT.LOP\PXD38HAG.NEBApp...UYN_cf5bed669b633588_0002.0000_7768b931aa8711fa\AppI")WinWaitActive("Login")Send("John")ControlClick("Login","","&Login")WinWaitActive("App")send("{RALT}")Send("{DOWN}")Send("{ENTER}")WinWaitActive("App - [input]")MouseClick("left", 237, 132, 1)WinWaitActive("App - [input]")Send("2024") /******** This is the place where i'm sending data. Now I want to include an excel file & from there i need to read & fetch data to the field, so that, there will be an iteration / Data Driven can be made. Kindly make suggestion of how it will be possible to do that? ********/ControlClick("App - [input]","","Save") Link to comment Share on other sites More sharing options...
JoHanatCent Posted November 25, 2011 Share Posted November 25, 2011 Try: _ExcelBookOpen _ExcelReadSheetToArray _ExcelBookClose Link to comment Share on other sites More sharing options...
water Posted November 25, 2011 Share Posted November 25, 2011 Your example script looks a bit cryptic. Could you please explain which program you try to automate? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
koushik6685 Posted November 25, 2011 Author Share Posted November 25, 2011 It is a windows Application, trying to automate windows forms. Need to send values from Excel to form fields, selec values from lisbox etc. ... Link to comment Share on other sites More sharing options...
water Posted November 25, 2011 Share Posted November 25, 2011 (edited) The approach with Send and Mouseclick might not work properly depending on what the user does while the script is running.I would suggest to send data to controls and click on buttons to use Control* functions.Edit:Example Edited November 25, 2011 by water My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki 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