Error 2147467259 80004005 Method
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Sun, 09 Oct 2016 08:42:00 GMT by s_ac4 (squid/3.5.20)
here for a quick overview of the site Help Center Detailed answers to any questions you might
Solution Runtime Error 2147467259 80004005
have Meta Discuss the workings and policies of this site About run-time error 2147467259 vba Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads excel runtime error -2147417848 (80010108) with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_winother/run-time-error-2147467259-80004005-method/325cf287-5593-4027-b3d1-494cb3cc7364 programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Run-time Error '-2147467259 (80004005)': Method 'Busy' of object 'IWebBrowser2' failed up vote 0 down vote favorite I'm getting Runtime Error -2147467259 (80004005)': Method 'Busy' of object 'IWebBrowser2' failed when I run the following code: (I am using Internet Explorer version http://stackoverflow.com/questions/38293046/run-time-error-2147467259-80004005-method-busy-of-object-iwebbrowser2 11 and ms Excel version 2013) Sub Get_UPC() Dim ie As Object Dim a As String Dim ASIN As String Application.ScreenUpdating = False Sheets("Extract UPC COde").Select Columns("A:A").ClearContents ASIN = Range("U2").Value 'changed by Shanti Oppenheimer 7/10/2016 'Set ie = CreateObject("InternetExplorer.Application") Set ie = New InternetExplorerMedium ie.Navigate "http://asintoupc.com/" ie.Visible = True **Do While ie.Busy And Not ie.READYSTATE = 4** DoEvents Loop DoEvents On Error Resume Next ''ie.Document.all.Item("MainContent_txtASIN").Value = ASIN Application.Wait (Now + TimeValue("00:00:02")) ie.Document.all.Item("MainContent_txtASIN").Value = ASIN ie.Document.all.Item("ctl00$MainContent$btnSearch").Click Application.Wait (Now + TimeValue("00:00:02")) With ie Do While .READYSTATE <> 4: Loop a = .Document.body.innerText 'other values can replace innertext, look up help for other options .Quit End With Range("A1").Value = a Set ie = Nothing SplitText AddtoList End Sub excel excel-vba web-scraping share|improve this question edited Jul 10 at 15:54 skkakkar 1,6262517 asked Jul 10 at 14:38 Shanti Oppenheimer 11 Works fine for me both New InternetExplorerMedium and CreateObject("InternetExplorer.Application"), can't reproduce error on IE 11 Excel 2010 32-bit. Try to run with Set ie = CreateObject("InternetExplorer
(80004005)' Method 'Open' of object'_Recordset' Failed If this is your first visit, be sure to check out the FAQ by clicking the link http://www.vbforums.com/showthread.php?439463-RESOLVED-Help-Runtime-error-2147467259-(80004005)-Method-Open-of-object-_Recordset-Failed above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from https://community.intuit.com/articles/1020391-run-time-error-method-returnaddress-of-object-envelope-failed-when-printing-envelopes the selection below. Results 1 to 3 of 3 Thread: [RESOLVED] Help Runtime error'-2147467259 (80004005)' Method 'Open' of object'_Recordset' Failed Tweet Thread Tools Show Printable Version Subscribe to this Thread… error 2147467259 Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Nov 23rd, 2006,02:24 AM #1 Haners View Profile View Forum Posts Thread Starter New Member Join Date Nov 2006 Posts 8 [RESOLVED] Help Runtime error'-2147467259 (80004005)' Method 'Open' of object'_Recordset' Failed I having a error when i trying to run a multilink query . i already test the error 2147467259 80004005 query on MS access it running perfectly on access but getting error on VB. may someone help me on this . thanks Last edited by Haners; Nov 23rd, 2006 at 02:30 AM. Reply With Quote Nov 23rd, 2006,02:31 AM #2 Haners View Profile View Forum Posts Thread Starter New Member Join Date Nov 2006 Posts 8 Re: [RESOLVED] Help Runtime error'-2147467259 (80004005)' Method 'Open' of object'_Recordset' Failed solve Reply With Quote Jul 7th, 2010,03:15 PM #3 claupe View Profile View Forum Posts New Member Join Date Jul 2010 Posts 1 Re: [RESOLVED] Help Runtime error'-2147467259 (80004005)' Method 'Open' of object'_Re Hey, I get the exact same error, could you tell me how you solved it? Reply With Quote Quick Navigation Visual Basic 6 and Earlier Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Visual Basic Visual Basic .NET VB.net CodeBank Visual Basic 6 and Earlier CodeBank - Visual Basic 6 and earlier Modern Windows Experience (Metro) Office Development Mobile Development ASP, VB Script Database Development Reporting API Games and Graphics Programm