chobo2

Ok, was hoping that was not the case.

No I am reading the entire worksheet in at once.

Do you mean I should use the flags? As I tried all of them I did not see anything else about formatting.

Hi I am using _Excel_RangeRead from Excel UDF. I noticed when it reads in my data it strips out number formating? Do I have set an option to stop this from happening? Example --> 1,000.00 is what I see in excel. Once _Excel_RangeRead has read in the excel row I see 1000 _Excel_RangeRead($excelWorkbook, $worksheetName) Is what I am using.

Just saying " writing good robust code with error checking" does not help me. What causes an autoit script to stop working? What should I be checking for? How do I catch an error that would case "autoit script stopped working"

Well like I said I get 2 errors. 1. Sometimes the scripts just stop working 2. Sometimes it is actually the custom application that stops working. Each script is run at one at a time. Each test is written as a function. There is one function that has all the tests in it. The first function(ie test) is called, once it finished it moves onto the next and so forth. This is where I run into problems as if I run each test manually one at a time it does not seem to have problems. It just seems to have problems when one after another happens. I

No Excel is not a custom application. But as far as my autoit tests use excel is to grab data out of it and use it in a custom application. If you want to see that code you can see it here as I am had problems with it in the past but now I have different problems(before it at least gave me an error now I am running into the script stopping) I am looking for general ways to figure out how to properly debug my scripts. Posting my scripts is not an option as I am finding out this error likes to move around. One day it dies on Script 5, next time it could be Script 8, next time it could be who knows. I would have to post so much code up that no one could run as you need the customer application that I don't see any benefit until I can narrow down the error. All tests run by themselves just fine. It is just went running one after another is when I see these problems

Here is one issue The script that I just got this error on was trying to load up excel to grab data from it(it never got past grabbing data....about 10 rows in that particular worksheet was trying to grab so very little of data) and then to use that data to validate if that same data by going through multiple screens(opening a window, check if whatever is there, closing that window, moving to a next window and so forth). How can I test if it is a hanging issue or a memory issue? What can I do to minimize the load on autoit Autoit?

I get 2 error message that randomly happen 1. "autoit script stopped working" 2. "app has stopped working. A problem caused the program to stop working correctly. Please close the program" Both happen sometimes and number 2 only happens when autoit tests are run. Never when used by people and its been used for a long time.

It is a custom application written a very long time ago. I just notice that somehow autoit can crash it. It is not always but all of sudden autoit will do something and the entire application will stop to respond and will show some cryptic error. No clue why it happens can't add more debugging to the app it is testing and it does not always happen. Then sometimes I will run my autoitscript and I will get "autoit stopped responding" and will say nothing else.

Hi I am wondering what is the best way to handle "autoit script has stopped working" and how to handle when the application autoit is testing crashes. I noticed sometimes that when I run my scripts I will get one of those 2 errors. It happens maybe once every 10 times but I would like to somehow be able to get information of why it happened(was it autoit that crashed the program or is there a bug in the program it is testing). Thanks

Yep both are 3.3.14.2 and it is the same workbook. It works sometimes that is the thing that confuses me so much. It can run like 5 times in a row just fine, then the 6th time it dies with that error. I look at see and I can see no excel process running or anything.

Thanks. It seems to have solved my issue on my local machine with Excel 2016 (but I am doing more testing) but on the other machine with Excel 2010 on it, now I get the exact same error. Seems like I can win. Should I be checking for something else to stop the error from popping up? So the script could try again or something.

I tried by removing all the functions and did this in all my scripts     Local $oExcel = _Excel_Open() Local $fileName = @ScriptDir &  "\Files\myExcel.xlsx"   Local $excelWorkbook = _Excel_BookOpen($oExcel, $filename)  $workSheet = _Excel_RangeRead($excelWorkbook, "Sheet1")  _Excel_Close( $oExcel) Same error.

I made the functions for code resuability as there is alot of checks to see if the object exists which I later log and such. I don't want to duplicate this code everytime I make a test(currently at 12 tests using this same code).