Excel VBA无法“单击”IE HTML中的按钮

Sub ClickHTMLButton()
    Dim IE As Object
    Dim HTMLDoc As Object
    Dim HTMLButton As Object
    
    ' 创建一个新的Internet Explorer实例
    Set IE = CreateObject("InternetExplorer.Application")
    IE.Visible = True
    
    ' 打开指定的网页
    IE.Navigate "https://www.example.com"
    
    ' 等待网页加载完成
    Do While IE.Busy Or IE.ReadyState <> 4
        DoEvents
    Loop
    
    ' 获取网页的文档对象
    Set HTMLDoc = IE.Document
    
    ' 根据按钮的属性查找按钮对象
    Set HTMLButton = HTMLDoc.getElementById("button_id")
    
    ' 模拟点击按钮
    HTMLButton.Click
End Sub