Jump to content
Sign in to follow this  
Yera

Mouseclick in Excel ver 10 Workbook

Recommended Posts

Yera

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!

Share this post


Link to post
Share on other sites
Bert

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.

Share this post


Link to post
Share on other sites
water

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 (2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2018-09-01 - Version 1.3.4.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
Yera

Hi, thanks for your replies. Will check these out.

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  

×