>>You should do it differently:
>>1. Link oWord to form property, i.e.
>>Thisform.oWordapp=Createobject("word.application")
>>2. Check VarType(Thisform.oWordapp) and IsNull(Thisform.oWordapp) in Form.QueryUnload to prevent closing.
>
>
>Yes. I understand. but the problem is the t oWord remains an object even if Word2007 is closed
>
>Peter
Pardon me for jumping in, but you would need to clean the reference yourself. I suggest to use visible property instead. It's not bullet proof, but it may be better and it worked for me in my tests for similar Excel problem.
If it's not broken, fix it until it is.
My Blog