Excel VBA运行时IE频繁崩溃问题求助

Hey there, no need to apologize for being a first-time questioner—IE automation is notoriously finicky, so you’re not alone here! Let’s go through some targeted fixes that don’t require rewriting your whole script to use xmlHttp:

• Clear IE’s Cache & Temp Files
  IE tends to hold onto cached data that can cause conflicts during repeated processing. Head to Internet Options > General > Browsing history > Delete and wipe temporary internet files, cookies, and browsing history. This often resolves random crash issues.

• Run IE in No Add-ons Mode
  Third-party add-ons (like toolbars or extensions) are a common culprit for script conflicts. Launch IE without add-ons by pressing Win + R, typing iexplore -extoff, then test your script. If it works, disable add-ons one by one to find the problematic one.

• Tweak IE’s Security Settings
  Overly strict security might block your script’s operations. Go to Internet Options > Security, set the zone for your target site to Medium-Low, and temporarily uncheck Enable Protected Mode (don’t forget to re-enable it later for safety).

• Force a Fresh IE Process
  Even with InternetExplorerMedium, IE might reuse a process with accumulated errors. Add this code to start a clean instance:

  Set ie = CreateObject("InternetExplorer.Application")
  ie.Visible = True
  ie.Navigate "about:blank"
  ' Wait for blank page to load before proceeding
  Do While ie.Busy Or ie.ReadyState <> 4
      DoEvents
  Loop
  

  This ensures you’re working with a fresh, uncluttered IE window.

• Fix Memory Leaks in Your Script
  If your script creates DOM objects or other resources without releasing them, IE’s memory usage can spike and crash. Make sure to set unused objects to Nothing after use:

  Dim targetElem As Object
  Set targetElem = ie.Document.getElementById("yourElement")
  ' Process the element
  Set targetElem = Nothing ' Free up memory
  

• Test with a Minimal Script
  Strip your code down to just the 15-row processing logic and see if the crash persists. This helps you narrow down whether the issue is in the data handling or another part of your full script.

Fingers crossed one of these gets you past the crash—IE automation takes patience, but small adjustments usually do the trick!

内容的提问来源于stack exchange，提问作者Jyuu