Yera Posted May 12, 2013 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!
Bert Posted May 22, 2013 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/
water Posted May 22, 2013 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 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Yera Posted May 22, 2013 Author Posted May 22, 2013 Hi, thanks for your replies. Will check these out.
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