User Specific - CreateObject("Word.Application") Fails

**Thanley** · 04-25-2013, 03:22 PM

I have an Excel macro linked to a button that opens a Word document. The document gets filled in with selections from Excel. It has been working for over a year with Excel 2003, 2007 and 2010. Now some of the users are getting the error "Microsoft Excel is waiting for another application to complete and OLE action." If I log into their machine with another's credentials it works as it should. If they log back in as they would normally, it gives them the same error again. I have followed nearly all of the links for the Microsoft error with no success. When I step through the code it fails with the second line below. Nothing is corrupt or missing. (It works for others.) Once this happens nothing seems to clear it. I have used Task manager to remove all instances of Excel and Word plus closing the winword.exe from processes. Even a hard shut down does not clear it.

Please Login or Register  to view this content.

**Thanley** · 04-30-2013, 03:03 PM

I am curious if I did not explain it right or posted to the wrong area since there has been no response. I am new to this Forum and want to belong.

**JosephP** · 04-30-2013, 03:16 PM

this type of problem is hard to diagnose because it is intermittent and appears related to a specific document which is probably why you got no response. also it's unrelated to excel ;-)

couple things to try
1. does the code work with other documents?
2. does the code work with the same document stored locally?

final question-is there any consistency in the users that the code fails with-same office version or os or add-ins?

**snb** · 04-30-2013, 03:24 PM

try:

Please Login or Register  to view this content.

**Thanley** · 04-30-2013, 06:02 PM

Thank you JP. I was concerned I may have offended someone in some way is why there was not a response. This problem is very difficult. I have only seen one other post that described my problem exactly and there was no solution for them either. The answer to both your questions 1 & 2 is No. Once a persons computer fails to launch Word, nothing seems to work or correct it. I feel like theres something cached in the registry to cause this but do not know where to look for it. If someone else logs into the defective computer with their credentials the code runs perfectly. My question to myself is what is different between user A and user B using the same machine.