AUTOIT BASICS

[rkr]

Hi, i am new to Autoit. I was trying to automate a simple process with excel on win10. the code is below. i initially ran with mousecoordinates set to screen option(default) - it ran seamless

#include <AutoItConstants.au3>
run("C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE","",@SW_MAXIMIZE)
;run(
winwait("Excel")
;MouseClick("left", 555, 272, 3, 0)
MouseClick("primary", 490, 351, 32, 0)
winwait("Book1 - Excel")
MouseClick("primary", 56, 236, 1, 0)
send("hello")
Send("{TAB 4}")
send("check")

.. the code was slightly altered, and when i opted mousecoords to window origin, excel window opens behind the active window ( i have to minimise the active window and click manually to continue from line 4 below)

#include <AutoItConstants.au3>
AutoItSetOption("MouseCoordMode",0)
run("C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE","",@SW_MAXIMIZE)
;run(
Global $a1, $a2 , $a3
$a1=1.0
$a2=2.5
$a3=$a1+$a2
winwait("Excel")
;
DirCreate ( "d:\xyz\abc" )
MouseClick("primary", 513, 227, 33, 0)
winwait("Book1 - Excel")
MouseClick("primary", 62, 242, 1, 0);Opt("MouseCoordMode",0)
;
send($a1)
Send("{TAB 1}")
send($a2)
Send("{TAB 1}")
send($a3)
mouseclick("primary",0,0,3,0)
;Send("{TAB 1}")
send("{enter}")
mouseclick("primary",218,352,1,0)
send("d:\xyz\abc\11.xlsx" )
send("{enter}")

 

[Jos]

You would want to use _EXEL_* Functions available in AutoIt3 in stead of trying to do this with mouse clicks/

Jos

Edited December 20, 2017 by Jos
Typo

[water]

I would first try the _Excel_* functions

[Jos]

Aren't we picky today ?

[water]

We are
I just undergo our yearly security audit. So I'm definitely in "picky" mode this week

[rkr]

thanks all.. is there a good book to go through for Autoit. i feel the online/autoit help file a bit non structured.. Eg; it doesnt explain why particular libraries are included.. i felt that the tutorial lacks a flow. please suggest

[water]

Please check the tutorials in the wiki. 

[BrewManNH]

14 minutes ago, rkr said:

Eg; it doesnt explain why particular libraries are included..

An easy way to figure out why something was included in the script is to comment it out and see what the result is.

[junkew]

@rkr not sure what you expect from a flow.  Tell your programming background and you get better direction. If you are a full starter in programming then its better to look on google for a base introduction in programming.

As given above it starts here https://www.autoitscript.com/ and from there you reach wiki, help, tutorials etc.

As you need excel you have to open it and then basically it starts here https://www.autoitscript.com/autoit3/docs/libfunctions/_Excel_Open.htm

And a full list https://www.autoitscript.com/autoit3/docs/libfunctions/

To me it does not make sense to say that include excel.au3 will help in reaching out to excel it certainly will not do something with ms word. And normally it works the other way around. When you are going to use a certain function the help will tell you which library to include. 

 

 

Edited December 24, 2017 by junkew

[Gianni]

On 20/12/2017 at 6:29 PM, rkr said:

... is there a good book to go through for Autoit ...

Here is one by @Jfish

 

Edited December 25, 2017 by Chimp