Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”

by

I ran into this same issue a while back. Use internet explorer at a medium integrity level. InternetExplorer defaults to a low integrity level which, if you are doing this over a local intranet at work, sometimes will give the second error message you show above.
Click here for more reading on this. I’ve modified your code below. Please let me know if that helps.

Sub GoToWebsiteTest()
Dim appIE As InternetExplorerMedium
'Set appIE = Nothing
Dim objElement As Object
Dim objCollection As Object

Set appIE = New InternetExplorerMedium
sURL = "http://example.com"
With appIE
    .Navigate sURL
    .Visible = True
End With

Do While appIE.Busy Or appIE.ReadyState <> 4
    DoEvents
Loop

Set objCollection = appIE.Document.getElementsByTagName("input")

Set appIE = Nothing
End Sub

Remember references for Microsoft Internet Controls, and depending on what you plan on doing further, Microsoft HTML Object Library

More Related Contents:

  1. How can I automate Save as dialog box in IE11 using VBA?
  2. In Excel VBA, what is the way to check if the web page is fully loaded?
  3. Excel VBA: auto click and open file from website
  4. VBA macro that search for file in multiple subfolders
  5. So, I have 6 “master” files to then divide into 40 separate files
  6. Getting ScriptControl to work with Excel 2010 x64
  7. Application.Match gives type mismatch
  8. Count and Highlight keywords within phrases
  9. Transpose a range in VBA
  10. Protecting cells in Excel but allow these to be modified by VBA script
  11. Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
  12. Detect merged cells in VBA Excel with MergeArea
  13. Using VBA code, how to export Excel worksheets as image in Excel 2003?
  14. Parse HTML content in VBA
  15. How to add a DocumentProperty to CustomDocumentProperties in Excel?
  16. How do I name a spreadsheet automatically, by referencing two cells?
  17. Excel VBA Delete Rows
  18. VBA EXCEL To Prompt User Response to Select Folder and Return the Path as String Variable [duplicate]
  19. Should I turn .CutCopyMode back on before exiting my sub procedure?
  20. Excel VBA – QueryTable AfterRefresh function not being called after Refresh completes
  21. Excel VBA: AutoFill Multiple Cells with Formulas
  22. VBA.Find and adding a value
  23. excel vba- extract text between 2 characters
  24. Round function in Excel, worksheet function vs VBA
  25. How to continue the code on the next line in VBA
  26. Excel VBA Userform – Execute Sub when something changes
  27. Count the number of rows in another sheet [duplicate]
  28. VBA Password Input with Cancel Function
  29. Finding first blank row, then writing to it
  30. VBA inheritance, analog of super

Leave a Comment