Jzullo

Hello all, once again I come to request the great help of the individuals in this forum. I'm trying to write a script that will copy the contents of a cell in Excel and store the contents in a variable. I will then use the contents of this variable to compare to a constant. The problem I'm having is that even when the statement is true, it goes to the else part of the If clause. What I have so far is below: $iShpCnd = ClipGet() MsgBox(0,$iShpCnd, $iShpCnd) If $iShpCnd = "02" then MsgBox(0,"First IF", $iShpCnd) WinActivate("XXXXXX") WinWaitActive("XXXXXX") MouseClick("left", 117, 337, 1) Send("02") Send("{Enter}") Else MsgBox(0,"Else", $iShpCnd) WinActivate("XXXXXX") WinWaitActive("XXXXXX") MouseClick("left", 117, 337, 1) Send("LD") Send("{Enter}") EndIf The "02" is stored as text in Excel, that's why I put it between "" in AutoIT. I tried putting switching the comparison, but it still goes to Else nonetheless. I really appreciate if anyone can shed a light on this.

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!

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: ;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

Thanks, Evilertoaster. I'll try to implement that method using the information you directed me to.

Guys, I need your help once again. Is there any UDF or other resource that I can use to use the Auto Filter function from Excel? I'm trying to filter a list and show whatever's blank. Once the list is filtered, I want to delete the rows. Thanks in advance.

Nahuel, you're the man! This is a major jump start for me. I am trying to better understand these array functions, one of my main issues was how to copy what the array is pulling to the clipboard, one at a time, but now I'being able to do this.

Nahuel, really appreaciate your help! I'm already using it with a few tweaks and it's working just great. I'll have two columns with valuable information to copy to the clipboard. I'll search a little bit how to separate these two sets of information. Hopefully it'll work out great.

Hello all, I'm new to this board and new to this AutoIt scripting. I have found this tool through college and really liked the possibilities this brings. I'm already trying to script something but I'm having a hard time in getting what I want done. What I need to do is the following: 1. Export the contents of table to a text or Excel file 2. Import the contents into an array in AutoIt 3. Pick the contents of the array, one at a time, and copy it to the clipboard 4. Paste the contents of the clipboard in a specific input field in the other application So far I was able to load the contents in an array using the array.au3, but I'm not being able to show the contents of the array one by one. I really appreciate the help you guys can provide.