Joining a sendkey and a variable

[Jzullo]

Once again, I'll have to rely on your help.

I'm trying to make a script that will count how many times the "For" has been run and associate this variable to the "send" command. Is it at all possible?

Just to be more descriptive: I have an Excel spreadsheet(rows will vary) where I have to copy the contents of a cell and paste it into another program. This will be repeated until the last cell contents. Here's the code I have so far:

expandcollapse popup

;Typing basic data
WinActivate("XXXXXX")
WinWaitActive("XXXXXXX")
ControlSend("XXXXX","","Edit1","va01")
Send("{Enter}")
WinWaitActive("YYYYYY")
MouseClick("left",136,177,1)
Send("AAAA")
Send("{TAB}")
Send("9999")
Send("{TAB}")
Send("l")
Send("{TAB}")
Send("00")
Send("{Enter}")

;Order Entry Screen
WinWaitActive("YYYYYY")
Send("ONEFACT")
Send("{TAB 3}")
Send("ONEFACT")
Send("{ENTER}")

_ExcelBookOpen($sFilepath, $fVisible, $fReadOnly)

    For $j = 1 to $iRowEnd - 4
        $Count=$Count+1
    WinActivate("XXXXXXX")
    WinWaitActive("XXXXXx")
    Send("{F5}")
    WinWaitActive("Go To")
    Send("J4")
    Send("{ENTER}")
    WinActivate("XXXXXX")
    WinWaitActive("XXXXXXX")
    Send("{CTRLDOWN}c{CTRLUP}")
    WinActivate(" ZZZZZZZZZZZ")
    WinWaitActive(" ZZZZZZZZZZZZZZZ")
    MouseClick("left", 198, 114,1)
    Send("{DEL 255}")
    Send("{CTRLDOWN}v{CTRLUP}")

;Pasting Street/House Number
    WinActivate("XXXXXXXXX")
    WinWaitActive("XXXXXXX")
    Send("{F5}")
    WinWaitActive("Go To")
    Send("K4")
    Send("{ENTER}")
    Send("{CTRLDOWN}c{CTRLUP}")
    WinActivate(" ZZZZZZZZZZZZZZZ")
    WinWaitActive(" ZZZZZZZZ")
    MouseClick("left", 198, 185,1)
    Send("{CTRLDOWN}v{CTRLUP}")
    Send("{DOWN $Count}")
        Next

[PsaltyDS]

From the help file under Send():

If you wish to use a variable for the count, try

$n = 4

Send("+{TAB " & $n & "}")

But... you are using _ExcelBookOpen(), which implies you are including ExcelCOM_UDF.au3, so why hack it like this when you have such a powerful tool available to just do the copy and paste directly? For example, _ExcelSheetUsedRangeGet() will tell you what the last row/column is, and with _ExcelCopy()/_ExcelPaste() this could be done much better.

[Jzullo]

Thanks PSalty! I know this methodology is not the brightest but I was writing it on the run and had to have that logic implemented quickly. I figured that implementing this using the regular functions AutoIT has I would be able to enhance it to use it better with the ExcelCOM UDF. For now, the previous method with a few arrangements will do the work. This afternoon I'll get to the script again and try to implement it using the Excel UDF.

The possibilities that AutoIT brings always amazes me, specially when we can ally it to UDFs.

BTW, I'm finding this forum one of the best I've participated on any kind of subjects. There's always someone willling to help.

Thank you once again!