The object invoked has disconnected from its clients Vbscript and internet explorer



Here was a vbscript that was working well and all of a sudden started throwing this vague error - "the object invoked has disconnected from its clients"

After a lot of research here is what I found that might save your day:

Find the handle of the window and re-associate the object with the handle. (This is what will reconnect your ie client back to the object"
Here is the code:

Set ie = WScript.CreateObject("InternetExplorer.Application")
With ie

     hwnd = .hwnd
     .Navigate "http://xyz.com"
End With

Set oShell = CreateObject("Shell.Application")

For Each Wnd In oShell.Windows
       If hwnd = Wnd.hwnd Then Set ie = Wnd
Next

  Happy Coding :)

Comments

  1. Anonymous25/6/13

    Just want to say your article is as surprising. The clearness on your publish is simply nice and that
    i can think you are knowledgeable on this subject. Fine
    together with your permission let me to clutch your RSS feed to stay updated with drawing close post.
    Thanks a million and please keep up the enjoyable work.



    Also visit my blog post; Shower Head Filter

    ReplyDelete
  2. Anonymous17/1/14

    Thank you very much. This was just what I needed when I needed it.

    ReplyDelete
    Replies
    1. Aditya Kalra (Ady)17/1/14

      Thanks , Glad that helped!

      Best Regards,
      Ady.

      Delete
  3. Anonymous8/2/14

    Excellent, solves vba CreateObject("InternetExplorer.Application") "The object invoked has disconnected from its clients" ... haven't found the cause yet, but this allows a workaround

    ReplyDelete
    Replies
    1. Aditya Kalra (Ady)8/2/14

      That's the best thing when someone else can benefit what you found way back! Glad it worked for you...

      Delete
  4. Anonymous12/5/14

    Wow! - Thank You.

    ReplyDelete
  5. Aditya Kalra (Ady)6/6/14

    You are welcome! :)

    ReplyDelete
  6. Anonymous11/6/14

    Thank you

    ReplyDelete
  7. Anonymous17/1/15

    Excellent. In my application I need to run through the loop to search for the window each time before I use the ie object. Odd thing is that on other machines I don't! Thanks very much.

    ReplyDelete
    Replies
    1. Aditya Kalra (Ady)18/2/15

      I am glad this worked for you!

      Cheers,
      Ady

      Delete
  8. Anonymous13/6/15

    Turning UAC off or running the script from elevated command prompt (Run as Administrator) solves the isue too. But your solution is better.

    ReplyDelete
  9. Aditya Kalra (Ady)15/6/15

    Cheers :)

    ReplyDelete
  10. Anonymous17/6/15

    Thank you sooooooooooo much, that solution really work out :)

    ReplyDelete
    Replies
    1. Aditya Kalra (Ady)17/6/15

      It's always good to see when things that worked for me in the past works for others!

      Delete
  11. Anonymous25/4/17

    I was using Set IE = New InternetExplorerMedium as most people recommended and it was working fine and all of a sudden I had this awful "disconnected" error that was driving me nuts! However, I've tried your method CreateObject("InternetExplorer.Application") and it finally worked!! The issue was with the creation method I guess. Thank you Thank you Thank you Thank you you've saved me hours of going nuts!!! :-)

    ReplyDelete
    Replies
    1. Aditya Kalra (Ady)26/4/17

      It's always cool when an old blog post still holds good.
      Cheers,
      Ady

      Delete
  12. Kaushal31/10/18

    PERFECT SOLUTION :)

    ReplyDelete
  13. yanmaneee30/1/21

    yeezy
    lebron shoes
    kobe shoes
    lebron shoes
    westbrook shoes
    curry 7 shoes
    canada goose
    yeezy shoes
    curry shoes
    jordans

    ReplyDelete
  14. Anonymous15/5/22

    Website louis vuitton replica click to investigate luxury replica bags go right here best replica bags

    ReplyDelete
  15. Anonymous18/7/23

    cheap jordans
    hermes outlet online
    palm angels hoodie
    off white hoodie
    hermes outlet

    ReplyDelete

Post a Comment

Popular posts from this blog

Software Testing @ Microsoft

Image
In continuation from my previous  series of posts  targeting testing in top few companies from the technology space. After  Software Testing @Facebook  and @Google  we shall now look at Microsoft: Testing@Microsoft Software Development Engineers in Test (SDETs) are usually just called Test and sometimes Software Testing. SDETs are responsible for maintaining high testing and qualityassurance standards for all Microsoft products. Software Development Engineers (SDEs) are often referred to as Software Development. SDEs write the code that drives Microsoft products and upgrades. Very few teams in Microsoft are still using SDETs to do significant amount of manual testing. Manual testing is mainly outsourced. Actually, as early as in 2004, for example, most of the manual testing of MSN Explorer was outsourced. Think about it this way: it just doesn't make sense for test manager to spend their headcount (SDETs) on something can be easily outsourced.  Until 2005, Microso
Read more

Trim / Remove spaces in Xpath?

Image
If you are wondering how you can trim the spaces in your xpath, this is how: The normalize-space function strips leading and trailing white-space from a string, replaces sequences of white-space characters by a single space, and returns the resulting string. Example : Which one is better? //td[starts-with(normalize-space(),'Text to Trim')] //td[starts-with(normalize-space(text()),' Text to Trim ')] The second option is better as it targets at the specific nodes More string functions in XPATH: Functions Description starts-with( string1 ,  string2 ) Returns true if the first string starts with the second string. contains( string1 ,  string2 ) Returns true if the first string contains the second string. substring( string offset length ) Returns a section of the string. The section starts at  offset (which is a number), and is as long as the value provided at  length. substring-before( string1 ,  string2 ) Returns the part of  string1  up unti
Read more