closing the word doc

[jishbalan]

Hello, i am creating my report table in word doc using VBA. When my application hangs and trying to open the word doc again, it says, document is locked by user or some time popup comes asking want to open as ready only. How can i close the word doc before opening it again. Thanks and regards Jishith

[kvelu d]

write the below code in closing event wrdDoc.Close(False) wrdDoc = Nothing wrdApp = Nothing or kill the application from the process

[Dave Kreskowiak]

jishbalan wrote:

When my application hangs

If your application hangs, you don't get the opportunity to close the file properly. That's why you can't open it on the next run. The system still thinks you have the file open. Your code cannot correct this situation, unless you manage to stop hanging in the first place.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008

[jishbalan]

Thanks for the reply.