Yera Posted May 12, 2013 Share Posted May 12, 2013 Hello, I am new to autoit and trying to left-click mouse (into a XL textbox) at a specific location in the currently active worksheet. My code is not clicking at the intended location. Am wondering what needs to be fixed. Here is my code: #include <Excel.au3> $sAppTitle = ( WinGetTitle("")) ; gets title of currently active XL inv window ControlClick($sAppTitle,"", "[CLASS:EXCEL7; INSTANCE:1]","left",1, 607, 144) ; got the Class and coords 607,144 via Autoit Window Info (x86) Many thanks! Link to comment Share on other sites More sharing options...
Bert Posted May 22, 2013 Share Posted May 22, 2013 If you are trying to access a specific cell then use Excel.au3. Your code shows you included Excel.au3 so you can reference the commands you need, but you then resort to generic windows actions to interact. Look in the help file for the excel commands and you will find all the answers you need. The Vollatran project My blog: http://www.vollysinterestingshit.com/ Link to comment Share on other sites More sharing options...
water Posted May 22, 2013 Share Posted May 22, 2013 If you try to automate XLSX files, give my rewrite of the Excel UDF a try. Unfortunately the Excel UDF that comes with AutoIt doesn't handle the new file formats very well. 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...
Yera Posted May 22, 2013 Author Share Posted May 22, 2013 Hi, thanks for your replies. Will check these out. 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