Controlclick vs mouseclick

[RonnieK]

Hi,

new to autoit, love the ability to automate tasks.

here is the issue:

I have an excel spreadsheet that copies / pastes data into an application

then deletes the row and repeats the process.

I can use mouse click fine IF the screen resolution doesn't change or the mouse doesn't move.

If either are changed the script runs off.

Is it possible to use control click to specify specific coordinates in excel (regardless of mouse location or screen resolution)?

for example right click and delete a row

here is what i'm writing:

ControlClick ("Microsoft Excel - Allocated Spending Plan [Compatibility Mode]"),"","","left",19,14,1")

this should click the edit class instance 2 to select the row

then eventually a right click select ("D") to delete it.

here is the autoit window info

>>>> Window <<<<

Title: Microsoft Excel - Allocated Spending Plan [Compatibility Mode]

Class: XLMAIN

Position: -12, -12

Size: 1944, 1064

Style: 0x15CF0000

ExStyle: 0x00000110

Handle: 0x0000000000140384

>>>> Control <<<<

Class: NetUIHWND

Instance: 2

ClassnameNN: NetUIHWND2

Name:

Advanced (Class): [CLASS:NetUIHWND; INSTANCE:2]

ID:

Text:

Position: 0, 238

Size: 1920, 56

ControlClick Coords: 19, 14

Style: 0x56000000

ExStyle: 0x00000000

Handle: 0x00000000000204E0

>>>> Mouse <<<<

Position: 19, 240

Cursor ID: 0

Color: 0xF9ECA6

>>>> StatusBar <<<<

>>>> ToolsBar <<<<

>>>> Visible Text <<<<

Status Bar

Status Bar

Ribbon

Ribbon

Calibri

11

General

Allocated Spending Plan [Compatibility Mode]

Vertical

Horizontal

>>>> Hidden Text <<<<

Vertical

MsoWorkPane

[Bert]

Look at excel.au3. It is built into AutoIt. You can find the information for it in the helpfile

[somdcomputerguy]

Is it possible to use control click to specify specific coordinates

Mouseclick clicks on coordinates, ControlClick clicks on controls, like buttons and whatnot. Edited September 3, 2011 by somdcomputerguy

[RonnieK]

Look at excel.au3. It is built into AutoIt. You can find the information for it in the helpfile

Mouseclick clicks on coordinates, ControlClick clicks on controls, like buttons and whatnot.

Thank both of you very much. As awesome as Autoit is, it can be a little overwhelming.