Automation Nation E.1 - Autohotkey and Excel

Показать описание

I'm transferring this over from my other channel that I put up a while ago. I plan to continue this segment of videos about automation on here.

As promised you'll find the link to Autohotkey and the code for the coordinate finder below. There is also the code from the video provided.

{
CoordMode, tooltip, Relative
SetTimer, Check, 20
return

Check:
MouseGetPos, xx, yy
Tooltip %xx%`, %yy%
return

Esc::ExitApp
}

A = 15
B = 240

InputBox, Lines, , Number of Lines

loop, %Lines%
{

{
Winactivate, Book2 - Excel
click %A%, %B%
send ^c
clipwait, 2

winactivate, Book1 - Excel
click %A%, %B%
send ^v
B += 20
}

ExitApp

Esc::ExitApp
}