使用Excel VBA在IE中点击Angular（ng-click）搜索按钮

Hey there! I totally get how frustrating it is when you're just starting out with VBA and can't get a simple button click to work—been there, done that. Let's break this down step by step to get that "GO" button working for you.

First, let's cover the most common pitfalls with secure websites and button clicks in VBA, then walk through targeted fixes based on the issues you might be facing:

1. Check if the Button is Inside an iframe #

Lots of secure sites use iframes to isolate content, and if your button is inside one, you can't access it directly from the main document. Here's how to switch to the iframe first:

' Replace "searchFrame" with your iframe's ID (check element inspector)
IE.Document.getElementById("searchFrame").contentDocument
' If you don't know the ID, use the iframe index (start from 0)
IE.Document.frames(0).Document

Once you've switched to the iframe's document, try your click methods again on this new document object.

2. Verify Your Element Selector is Correct #

If your 6 methods didn't work, chances are the selector isn't targeting the right element. Double-check the button's properties in the inspector:

• If it has a static ID: Use getElementById (most reliable if ID doesn't change)

  IE.Document.getElementById("your-button-id").Click
  

• If it uses a class name: Remember getElementsByClassName returns a collection—you need to specify the index:

  IE.Document.getElementsByClassName("your-button-class")(0).Click
  

• If it's a submit button: Try submitting the parent form instead of clicking the button:

  IE.Document.getElementById("search-form-id").Submit
  

3. Trigger the Right Event (Not Just Click) #

Some buttons rely on specific JavaScript events (like onclick, mousedown) instead of the default Click method. Try firing the event directly:

' For older IE versions
IE.Document.getElementById("your-button-id").FireEvent "onclick"

' For modern browsers (if using IE11+)
Dim evt As Object
Set evt = IE.Document.createEvent("HTMLEvents")
evt.initEvent "click", True, False
IE.Document.getElementById("your-button-id").dispatchEvent evt

4. Wait for the Page/Element to Fully Load #

Secure sites often load content dynamically or slowly. Make sure the button is actually present before trying to click it:

' Wait for the page to finish loading
Do While IE.Busy Or IE.ReadyState <> 4
    DoEvents
Loop

' Wait specifically for the button to appear
Do While IE.Document.getElementById("your-button-id") Is Nothing
    DoEvents
Loop

5. Check if the Button is Disabled #

Sometimes the "GO" button stays disabled until form fields are filled correctly. Enable it first if needed:

With IE.Document.getElementById("your-button-id")
    If .Disabled = True Then .Disabled = False
    .Click
End With

If you can share the exact element HTML from your inspector (like the button's tag, ID, class, and any onclick attributes), I can give you an even more tailored solution. But start with these steps—they fix 90% of button click issues in VBA for secure sites!

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