Opening word docs bug

**samnic** · 05-28-2011, 08:04 AM

I'm having a problem opening word documents from within an Excel marco. Here is my code

Please Login or Register  to view this content.

Up to "set wdapp" works fine, and an instance of microsoft word opens. However, I can never get the word document open. I just stays on that line of code for more than a minute, then I have to kill WinWord in the task manager to get back control of excel.

Has anyone had this prob before?

**TMS** · 05-28-2011, 12:39 PM

Try:

Please Login or Register  to view this content.

Regards

**samnic** · 05-29-2011, 02:21 AM

Thanks for the reply.

I think the initial problem had something to do with trying to create a new instance of word when one was already running. Additionally, since I was terminating the word process using the task manager all the time the word document became corrupted and this caused VBA to get stuck on the wdapp.documents.open line.

Thanks for the advice all the same.

**TMS** · 05-29-2011, 02:57 AM

The problems that I addressed were that you'd used a different variable, than the one you'd defined, for the document and I made the word application visible so that I could see what was happening. This makes it easier to debug and to close the word application if the code doesn't do what you expect. You could have several instances of word without knowing .

Anyway, if your problem has been answered, please mark the thread as solved. See my signature for details or the FAQ.

Regards