excel delete duplicate row windows

[Queener]

for some reason this code doesn't seems to effect when I run the following code:

global $title = "Microsoft Excel"
 
if WinExists($title) Then
   WinActivate($title)
   winactive($title)
   sleep(1000)
   ControlClick($title, "", "[CLASS:Button; INSTANCE:1]")
EndIf

 

Can someone verify?

[JLogan3o13]

How about a more defined explanation of what you are trying to do? With the Excel UDF, I am quite sure there is an easier way than using ControlClicks.

[water]

That's corect. Don't automate the GUI, use COM by using the Excel UDF (or my rewrite).

[Queener]

Nevermind, I figured.

recorded macros then have autoit execute the macros.

Edited February 7, 2014 by asianqueen