Creating Excel from within VB6

[AOLBoy]

I have programmatically created an Excel spreadsheet from my VB6 program. I then go on to update the Excel spreadsheet by creating new sheets and adding data into those sheets.

My problem is that is an inconsistency in its performance - in some cases the process works fine, but at other times it fails because the create hasn't worked. If I run in debug it always works. I suspect that the program is trying to access the spreadsheet before the create operation is complete. Can this happen?, has anybody experienced this before?, is their any sort of wait operation that can be applied?

Any help would be much appreciated.

 

[JerryKlmns]

Would you post the offending code?

 

[TysonLPrice]

Check that you are closing down properly and destroying the objects. When it starts failing go to the task manager and see if you have multiple versions of Excel running.