this is strange (write data into excel)

[ramiral]

The aim of my program is to write into 3 sheets in excel like this: the first column is always the same and the second is what the user want to insert.
When I run the program for the first time and I press OK to write data into excel it works and It launch excel and ask to save . But When I press, after, OK for the second time to write, excel ask to save but I can't see data (the area is grey and no cell appear) and what is strange is that if I launch separately excel (after having pressed OK for second time) I can't see cells inside excel.
In fact if I want to write 3 or 4 times I need to stop my program and restart it each time..

[ramiral]

I have printed the screen:

[ramiral]

I forgot to say that even if it's grey , I can save data (without seeing data) and whaen I stop my program I can see cells.

[shoneill]

Have you tried checking in the task manager that your Excel program is really being closed? If you're communicating via ActiveX, you need to be very careful about the order in which you close all of the object references. If one is left out or in the wrong order, Excel will "disappear", but it will remain in memory. This may cause a conflict which is causing your problem.

Just an idea

Shane.

[ramiral]

Ok , I tried with only one sheet and in fact I forgot one automation close...
For 4 sheet, do I need one automation close for each 4 sheet?

[ramiral]

Ok now it works, I put one automation close after each sheet and it's Ok
thanks