View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default intermittent error - ActiveX component can't create object

Look in the task manager an make sure you are actually releasing those
instances of Excel. I suspect you are not.

--
Regards,
Tom Ogilvy

"Naveen" wrote in message
...
Hello

I have a VB 6 routine that does a lot of iterations. In each of the
iteration there is Excel manipulation.

Since MS Excel is extremely temperamental I create and destroy all Excel
objects in the correct order within each iteration.

The problem I face is that after about 50 iterations or sometimes a 100,
Excel object creation suddenly fails with the above error.

Any ideas why this would happen.

Thanks
Naveen