Clipget Or Clipboard Error

[herewasplato]

The code below is used to read a column of data from a spreadsheet.

The data in the array $pinID [$i] is not always correct.

I have set SendKeyDelay from 1 to 1000 and it still happens sometimes.

Sometimes the error occurs in the first cell other times the 1000th cell.

I can run the entire script several times and after a while, no errors will occur (well no errors after 20 runs - each with 4000 cells) restarting the computer seems to give the greatest chance that the errors will happen again. After 4 to 7 errors, you will probably be error free for each subsequent run.

The difference between the "temp" variable and the "pinID" variable is usually one cell (the temp variable still had the value from the last loop) but sometimes the temp variable has a value from several loops back???

I've messed with the clipboard settings within Excel thinking that somehow they fed the temp variable the wrong info at the wrong time... nothing helped.

The errors occurs on a relatively slow (500MHz) XP system using Office 2002(XP) and on a 2GHz system running the same OS/Office. I've also tried it using Office 2003.

I've used sleep statements most everywhere to no avail.

WinWait ("Microsoft Excel", "")
WinActivate ("Microsoft Excel", "")
WinWaitActive ("Microsoft Excel", "")
Send ("^{HOME}")


For $i = 1 to $pinCNT
     WinWaitActive ("Microsoft Excel", "")
     Send ("^c")
     $temp = StringTrimRight (ClipGet (), 2)
     Send ("{ESC}")
     Send ("^c")
     $pinID [$i] = StringTrimRight (ClipGet (), 2)
     If $temp <> $pinID [$i] Then
          MsgBox (0, "AutoIt",_
          "**" & $temp & "**"  &_
          @CR & "**" & $pinID [$i] & "**"  &_
          @CR & "Clipboard error" &_
          @CR & "Start over")
          EXIT
     Endif
     Send ("{DOWN}")
Next

Any suggestions?

Thanks in advance...

[Valik]

It might be running too fast. Sprinkle in a Sleep(50) or something after each loop and see if that reduces the errors.

[herewasplato]

I've tried a single sleep 1000 statement within the loop... far fewer crashes, but still crashes... so, I tried sleep ($slp) statements every other line of the loop... where $slp was changed from 5 to 150. That slows it down to what seems stable, but testing that stability will have to wait until I have multiple systems to run it on.

Any guesses as to where "sleeps" would be most useful within the loop?

Is it faster and more stable to save the spreadsheet to text and read that in?

[Valik]

It would be, yes. You can load the entire text file into memory in one shot with this:

$szFile = "Path\To\File.txt"
$doc = FileRead($szFile, FileGetSize($szFile))

[herewasplato]

Thanks - I will look into learning that part of AutoIt.

As you can see by the time between my posts, I only work on this stuff when time permits... so a belated thanks.