excel blank cells

[amose]

hi
when trying to write to an excel file using activeX, some of my data is lost if i do something else on the PC while the data is writen.(see example)
how can i ensure that all the data is properly writen?
amose

[K C]

Hi,

Strange never seen this with my programs. I use(d) programs to write Excel and Word without any problems.

Did you wired all the error clusters ?

[amose]

this is what i use

[K C]

Hi,

I am missing the VI in the for-loop. Can you post this as well (with any VI's inside)

You should wire the error cluster to shiftregisters in both loops. Otherwise it is possible that an error will not show up at the output.

[amose]

i get this error code: -2146777998 when disturbing the write to excel file process with this VI:

[K C]

Hi,

Cannot really help there, but I have some suggestions:

Did you tried to write a array at once to Excel ?

Normally I use a the 'to variant' function before passing the data to Excel.

When I think of something else I will let you know.

[Michael_Munroe]

ActiveX will only work if Excel is in an idle state.  If you are editing a cell or pulling down a menu, the ActiveX calls will not allow you to write to any cells.  Also, if your data is being written to the ActiveSheet and the user changes the sheet, your data might go to the sheet being viewed.

You can read-verify every write to verify the exchange if the user is interacting with Excel and buffer data that was not written until the user is done.