在IE EXCEL和VBA交互中模拟双击事件 [英] Simulate Double Click Event in IE EXCEL , VBA interaction

问题描述

不能使用fireevent，因为它暂停了所有宏代码 所以我需要模拟双击事件 或是否有人愿意调查问题并提出解决方案 ..

Cant use fireevent because it halted all macro code so i need to simulate the double click event or if anyone kind enough to look into the problem and suggest a solution ..

推荐答案

我创建了一个示例来重现该问题，似乎在显示提示时，VBA脚本将挂起并等待我们处理提示.除非我们处理提示，否则我们将无能为力.

I have created a sample to reproduce the problem, it seems that when the prompt displaying, the VBA script will hang and waiting for us to handle the prompt. Unless we handle the prompt, we can do nothing.

作为一种解决方法，我建议您尝试使用 Selenium IE网络驱动程序，方法，单击按钮后，我们可以切换到弹出窗口，然后单击确定/取消"按钮.

As a workaround, I suggest you could try to use Selenium IE webdriver, By using this method, after click the button, we could switch to the popup window, then click the OK/Cancel button.

更多详细信息，您可以查看以下文章:

More detail information, you could check the following articles:

Python Selenium句柄警报提示确认弹出窗口

这篇关于在IE EXCEL和VBA交互中模拟双击事件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！