Controlling Internet Explorer local intranet using Excel VBA

by

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

More Related Contents:

  1. Automate IE via Excel to fill in a dropdown and continue
  2. VBA WinHTTP to download file from password proteced https website
  3. Get existing IE via VBA
  4. Save excel file multiple times with file names in another workbook.
  5. How do I find the last column with data?
  6. Excel VBA: Answer gets “stuck”
  7. How to insert a picture into Excel at a specified cell position with VBA
  8. Save multiple sheets to .pdf
  9. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  10. Excel VBA autofilter all but three
  11. How can I create a calendar input in VBA Excel?
  12. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  13. Merge values of column B based on common values on column A
  14. How to import a table from web page (with “div class”) to excel?
  15. Range limit conundrum
  16. Concatenate cell data into another data if values matches
  17. Iterating through populated rows
  18. How can I run VBA code each time a cell gets its value changed by a formula?
  19. How to convert 32 bit VBA code into 64 bit VBA code
  20. Using VBA to detect which decimal sign the computer is using
  21. Loop through each row of a range in Excel
  22. Outputting Excel rows to a series of text files
  23. How to create a range from two ranges in VBA?
  24. XML parse VBA excel (function trip, & MSXML2.DOMDocument)
  25. every possible combination of the contents of 2 columns in excel
  26. excel vba freeze pane without select
  27. How to delete rows in Excel based on criteria using VBA?
  28. Converting a string representation of a constant into a constant?
  29. Function Overloading and UDF in Excel VBA
  30. VBA Excel simple Error Handling

Leave a Comment