+ Reply to Thread
Results 1 to 6 of 6

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

  1. #1
    Registered User
    Join Date
    02-13-2013
    Location
    Gun Barrel City
    MS-Off Ver
    Excel 2010
    Posts
    6

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

    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.

  2. #2
    Registered User
    Join Date
    02-13-2013
    Location
    Gun Barrel City
    MS-Off Ver
    Excel 2010
    Posts
    6

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

    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.

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

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

    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?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

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

    try:
    Please Login or Register  to view this content.



  5. #5
    Registered User
    Join Date
    02-13-2013
    Location
    Gun Barrel City
    MS-Off Ver
    Excel 2010
    Posts
    6

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

    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.

  6. #6
    Registered User
    Join Date
    02-13-2013
    Location
    Gun Barrel City
    MS-Off Ver
    Excel 2010
    Posts
    6

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

    SNB,

    I will try that tomorrow and let you know what happened. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1