multiplying variable every loop

[beekeeper222]

I want to make a scrip that does a simple action in excel, by clicking on each unit, doing a simple action and then moving to the higher/lower unit, I came up with that idea, but don't know how to multiply variable $moveY x+1 time every time loop runs

$OriginalX = MouseGetPos(0)
    $OriginalY = MouseGetPos(1)
    $MoveX = 0
    $MoveY = -73
Dim $i=1
While $i<=10
  ;Action
   MouseMove(403,964) ;starting unit coords
    MouseMove($OriginalX + $MoveX, $OriginalY + $MoveY)
   WEnd

 

[Subz]

Why not use the Excel UDF included with Autoit?

[beekeeper222]

What is that?

 

[Subz]

If you look at the AutoIt help file, you'll see the _Excel_... functions, along with examples.

[beekeeper222]

But i'd have to write the script all over again, that one is almost completed, I only need to apply the multiplyier, don't tou know how to do that?

[jdelaney]

For $i = 1 To 10
    ;Action
    MouseMove(403,964) ;starting unit coords
    MouseMove($OriginalX + $MoveX*$i, $OriginalY + $MoveY*$i)
Next

 

Edited May 30, 2020 by jdelaney

[Subz]

Sure, you just change $MoveY each time you click, but wouldn't recommend this method for Excel, in fact I rarely recommend mouseclick or send for anything.

[beekeeper222]

jdelaney that is exactly what I wanted, thak you guys so much for help

[Musashi]

9 minutes ago, beekeeper222 said:

But i'd have to write the script all over again, that one is almost completed

I agree with @Subz !
Your script may seem almost completed to you, but you are using a rather unreliable approach. It should not take too much effort to rebuild the script using the Excel UDF. On the long run, you will probably even save time if, for example, extensions are required.