Run-time error help

[Hap]

Maybe someone can help explain this to me and how to go about resolving it?

Run-time error '-2147417848 (80010108)':

Automation error
The object invoked has disconnected from its clients.


Thanks for any help

 

[nightcrawler23]

For better help, may be you can post some code and the line at which error occurs.

 

[Hap]

It started occuring before I ran my program. It was on opening the vb editor of an macro enabled workbook. Previous to this error Excel started acting like the file was corrupt and would exit when I tried opening the file. After waiting awhile the file opened but gave this error instead. Still haven't run my program. There is code on the "This workbook" module though.

Thanks for any help.

 

[nightcrawler23]

May be there is some code for Workbook_Open event.

 

[Hap]

Last thing I did before all the problems started was created a UserForm to replace a form I already had. When all the form work was done I just renamed the form so that all other references to it would be the same. Clearly this didn't work as planned. I removed the earlier version of the form and that didn't solve the problem either. Anytime I try to run the code opening the form Excel shuts down on me.

 

[nightcrawler23]

Sorry, Office time, Gotta go. May be some one else can help.