Forum Discussion
VBA Automation Internet Explorer popup window button click
Sub CDOpenDuplicate() Dim ieapp As New InternetExplorerMedium Dim Doc As New HTMLDocument 'Set ieapp = New InternetExplorerMedium With ieapp .Visible = True .navigate "http://xxxx.cvxc.l...
Two workarounds
1.IE button to click on the automation:
Dim IE As Object
Set IE = CreateObject(InternetExplorer.Application)
IE. Navigate web page URL
IE. Document.getElementById(button ID). Click is replaced with the actual button ID
2. Skip pop-up warnings:
IE. Visible = True to show IE window (to avoid silent mode being blocked)
Application.SendKeys {ENTER} auto-confirm pop-up