_ExcelWriteCell() Doesn't Write Text To Cell

[Mongoose 0]

I have a script that opens an Excel file that is stored on a network drive and updates some of the cells using _ExcelWriteCell.

Occasionally, the Excel file will open just fine but the target cells don't get updated.

What could be causing this behaviour?

The relevant lines of code are as follows:

$oExcel = _ExcelBookOpen($FileName)

_ExcelWriteCell($oExcel,$FileNumber,"E" & $k)

[water 2,341]

You need to add some error checking to your script!

What is the value of $FileNumber, what is the value of $k, what is the return value of _ExcelWriteCell, what is the value of @error and @extended after calling _ExcelWriteCell?

[Mongoose 0]

I can do the error checking.

My real question is whether anyone else had experienced anything similar and what could have caused this anamolous behaviour.

[water 2,341]

We need the information I asked for in my above post to really help you.

[redpicker 2]

I can do the error checking.

My real question is whether anyone else had experienced anything similar and what could have caused this anamolous behaviour.

Although I am not a very advanced user, I do use the Excel functions quite a bit, and Yes, I have experienced this behavior before. Usually, it is because there was a problem with the _ExcelBookOpen command syntax or that of the _ExcelWriteCell. The Error checking suggestions will probably lead you to the solution. If not, posting the results here will. In my experience, it is usually badly hacked code that isn't doing what I expect it to be doing; sometimes, despite my errors, it works out and writes to the intended cell despite my mistakes, othertimes it doesn't.