XLSheet to Array trouble

[Bob Hansen]

I have been getting a random error with the XSheetToArray command.

Code: Select all

XLSheetToArray>%vFileName%,Sheet2,vResults

I get the error, sometimes, when running real time.
If I single step through the script, I will get an error message:
"A lock violation has occurred."

I can still continue to single step through the script bu I have no vResults array values to work with. When it works properly, the array is complete with no problems.

But when I get the error, the only way I can stop it is to Exit Macro Scheduler completely. Just exiting the script, or closing the Control Panel to the Notification Area, does not good.

Excel is not open, so there should be no lock from there. This is early in the script and the spreadsheet is not called for anything before this.

Who has the "key" to make the "lock" error go away?

[Marcus Tettmar]

This does suggest that something else has the file open. May be there's a stray Excel process that hasn't closed down properly - have a look in Task Manager.