Internet Explorer Automation Error The Interface Is Unknown
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this internetexplorermedium site About Us Learn more about Stack Overflow the company Business Learn more
The Object Invoked Has Disconnected From Its Clients Vba Internet Explorer
about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss excel vba automation error the object invoked has disconnected from its clients Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Excel VBA Controlling vba internet explorer medium IE local intranet up vote 10 down vote favorite 4 So, I am using Excel VBA code to click a button on our website, trust me, I know this isn't the best of things to be doing, but it is the least objectionable option available to me at this time. So, that choice out of the way, here is my problem, I can using
Internetexplorermedium Vba Reference
this code, successfully load imdb.com, google, etc. But when I load our local site, I lose control of the ie object, I can't check readyState, I can't Quit. Here is the error I get. Run-time error '-2147023179 (800706b5)': Automation error The interface is unknown Every so often I instead get this message: Run-time error '-2147417848 (80010108)': Automation error The object invoked has disconnected from its clients. Clicking Debug indicates the ie.readyState, I also tried commenting that out and then it points to ie.Quit Sub dothestuff() Dim ie As InternetExplorer Set ie = New InternetExplorer ie.Visible = True ie.Navigate "http://www.google.com/" anerror = webload(ie) ie.Quit Set ie = Nothing End Sub Function webload(ie) Do Until ie.ReadyState = READYSTATE_COMPLETE DoEvents Loop End Function internet-explorer excel-vba share|improve this question asked Oct 18 '12 at 22:59 Varyl 1151110 add a comment| 10 Answers 10 active oldest votes up vote 16 down vote Here is a quick and easy solution for this issue: Instead of: set IE = createobject("internetexplorer.application") Use: Set IE = New InternetExplorerMedium No need to tweak the IE settings share|improve this answer edited Oct 7 '13 at 9:54 laalto 91.7k23126169 answered Oct 7 '13
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsRepositoryCommunityForumsBlog Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Code 800706B5 The Interface is Unknown - Windows 7 - IE 9 - Vbscript Scripting > internetexplorermedium "user-defined type not defined" The Official Scripting Guys Forum! Question 0 Sign in to vote I do internetexplorermedium object have a very big issue for which i look forward to get a solution. The issue is that all this
Add A Reference To Microsoft Internet Controls
vbscript code was working in a Windows Vista Machine with IE 7. But I do want the same code to even run on Windows 7 Machine with IE 9. But when i http://stackoverflow.com/questions/12965032/excel-vba-controlling-ie-local-intranet tried to run, i get the following message "Code 800706B5 The Interface is Unknown" just after the navigation to required URL is completed. More clearly I get this error when IE object is accessed again after navigation. Please help me as this is very critical for me. eg. Do while (IE.Busy) WScript.Sleep (200) Loop -------------------------------------------------------------------------------------------------------- Full Source Code Set WshShell = CreateObject("WScript.Shell") Set IE = https://social.technet.microsoft.com/Forums/scriptcenter/en-US/49f829b6-3c04-403c-97b0-6480aaba3fbe/code-800706b5-the-interface-is-unknown-windows-7-ie-9-vbscript?forum=ITCG CreateObject("InternetExplorer.Application") IE.Navigate ("http://URLOnMyIntranet//?cid=6&c=12&cpc=dt2wJiVUfnQ2") IE.Visible = True WshShell.AppActivate IE wscript.sleep 2000 WshShell.AppActivate IE WshShell.SendKeys "username" WshShell.SendKeys "{TAB}" WshShell.SendKeys "password" WshShell.SendKeys "{ENTER}" Do While (IE.Busy) wscript.sleep 200 Loop ------------------------------------------------------------------------------------------------- i believe when WScript.Sleep 2000 is called the IE object becomes invalidatedLinson Monday, February 13, 2012 2:39 AM Reply | Quote Answers 0 Sign in to vote since i'm launching the IE from script, how can i make it open with elevated privileges? Linson Open a command prompt with elevated privileges and then run the script. ¯\_(ツ)_/¯ Marked as answer by LINSONMATRIX Thursday, February 16, 2012 7:16 PM Wednesday, February 15, 2012 8:21 PM Reply | Quote All replies 0 Sign in to vote I do have a very big issue for which i look forward to get a solution. The issue is that all this vbscript code was working in a Windows Vista Machine with IE 7. But I do want the same code to even run on Windows 7 Machine with IE 9. But when i tried to run, i get the following message "Code 800706B5 The Interface is Unknown" just after the navigation to required URL is completed. More clearly I get this e
be down. Please try the request again. Your cache administrator is webmaster. Generated Wed, 19 Oct 2016 04:04:56 GMT by s_wx1011 (squid/3.5.20)