sho

Neither. I am basically doing a while loop to search on the IBM I series screen for a specific text, then write to excel only when the text is found. The excel file is a simple blank excel with only some headers, nothing too special or too huge in filesize. Is just that the while loops can run up to a few hundred, for an hour or more.

Sorry, I would very much love to paste the entire script here, but it is in my organisation pc and I can't access the Internet on it, so I am typing the section of the script which the rangewrite failure have occurred based on the previous observations. The excel is ver 14, 64bit, professional plus 2010. AutoIt version is 3.3.14.5 Win OS is win7.

V3.3.14.5 The error box basically just displayed the line of the script which contain the rangewrite function. And whenever I traced it back, it is always the rangewrite right after the while loop.

Hi jchd, thank you very much for replying. Basically the part where using X86 will crash is the excel range write after performing more than 300 while loops: While $ops.searchtext("text to search for") = false Sleep(10000) Wend _Excel_RangeWrite($oWorkbook, $oWorkbook.Activesheet, "Pass" , "A3") I am doing a while loop to check for a status update on the Iseries screen. However, sometimes it can take up to a few hundred loops before the required text is found. No issue when it is less than 300 loops or when using X64. Repeated the test on a simple text file instead of Iseries application, the same problem will occur when it is more than 300 loops. By the way though I have found an alternative to get the screen text (by copy all, clipget, stringinstr), it is not the ideal way. Was hoping $ops.searchtext could work. But seems like I am currently stuck between get $ops.searchtext to work or getting while loop to work.

Hi I have previously written a script to create object and set connection name to Session A, as follow: $ops = ObjCreate("PCOMM.autECLPS") $ops.setconnectionbyname("A") $ops.searchtext("text to search for") The above went well when I executed the script using AutoIt3.exe However when I execute it using AutoIt3_x64.exe, it failed as it was unable to create object. Basically, I am trying to search for a specific text on the IBM iseries screen using the function $ops.searchtext("text to search for"). However I am just unable to get this to work using AutoIt3_x64.exe Is there any alternative method? I have tried winexist("Session A", "text to search for"), but it is also not working. I am using AutoIt3_x64.exe as it is more stable than AutoIt3.exe, as AutoIt3.exe keeps crashing after performing multiple loops. Many thanks in advance for any advice.

Thanks for the reply.

Hi, I am trying to search for a solution for this and couldn't find much information, hopefully can get some advice here. Thanks alot. I have an autoit script which is already running, extracting information from an internal system, and storing the data as three sets of array variables. Separately I have a python py script with a defined function, processing some data cleaning on these three arrays and generate a txt file. I am trying to combine the two processing scripts (autoit and py) together, such that after the process completed in autoit with the output of 3 arrays, I can execute the py script and pass these 3 arrays into the py function. I have managed to use either runwait or shellexecute to execute the py script, but I was unable to pass the 3 arrays variables into the py script function, as result it has been generating an empty txt file. Example: Final output in autoit: $array1 $array2 $array3 In my py script : def dataclean(array1, array2, array3) : some data cleaning steps return (txt output) dataclean(array1, array2, array3) How can I assign array1 in py script to $array1 in autoit? Thanks alot in advance.

Hi, let me apologized in advance in case my question sounded silly. I am completely new to AUTOIT and scripting languages, and was searching for solution to automate a process and came across AUTOIT. In summary, I have a list of commands saved as word or excel file, which I will copy each command one at a time into AS400 and execute it. Is it possible to use AUTOIT to automate this process and if there is any example scripts which I can learn or reference to? Any form of advice or help is welcome. Thank you so much in advance.