intermittent error - ActiveX component can't create object

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Look in the task manager an make sure you are actually releasing those
instances of Excel. I suspect you are not.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Out of resources error message - when not... 3
Creating a Custom Worksheet Object 5
VBA fails with Run-time Error 429 "ActiveX component can't create object" 1
"Run-time error 429: ActiveX comonent can't create object" MSComm 5
manipulating drawing objects in MS Office 2007 2
ActiveX component can't create object or return reference to thisobject (Error 429) 4
newbie q - create list of objects from excel worksheet 1
help on "scripting.filesystemobject" 3

Back
Top