Runtime error 429

[xana]

I'm trying to run code and getting Runtime Error 429- ActiveX component can't create object when it tries to create a workspace. the code worked on this computer before i had to do a system recovery, so i'm assuming that something is now missing or installed incorrectly. any ideas? thanks!

-xana

 

[Databaseguy]

429 is a Bear. It has many causes, and Microsoft gives you about 20 different fixes. Go to the knowledge base and search on it.

In my experience, the main cause has been Explicitly instantiating objects in lieu of implicitly instantiating the Word object. Again, their web site will expound on this.

Also, wherever you refer to a property of the word object in your code, make sure and preface it a fully qualified reference. Example: objWord.Documents(1).Property in lieu of .Documents(1).Property. This will eliminate OLE application server errors. Before I fixed my code up, Word would only start every other time...