使用VBS无法点击无ID按钮，请求技术解决方案

Hey there, let's work through this frustrating issue together. I know sinking hours into testing existing solutions here and still hitting a wall is no fun—Oracle EBS automation can be notoriously tricky, so I feel your pain!

First, let's recap what you've shared: your search functionality works as expected (it redirects to the target page), but you're stuck when trying to interact with the "Clear" button on that redirected page. It looks like the code snippet for the Clear button got cut off in your message—could you share the full code for how you're attempting to trigger that button?

In the meantime, here's your current VBA code formatted for clarity:

Dim URL
Dim IE
Set IE = CreateObject("internetexplorer.application")
IE.Top = 0
IE.Left = 0
URL = "https://ebsprod.utg.uvn.net:4443/OA_HTML/OA.jsp?page=/oracle/apps/icx/por/reqmgmt..."

A few quick troubleshooting angles to consider while we wait for the Clear button code:

• Wait for full page load: Oracle EBS pages are often slow to fully render. Make sure you're adding a proper wait (either checking IE.Busy or using a timed delay) before trying to interact with any elements on the redirected page.
• Element targeting best practices: Oracle EBS frequently uses dynamic IDs for elements. Instead of relying on static IDs, try targeting the Clear button by its name attribute, visible text, or a consistent XPath.
• Check for iframes: Many Oracle EBS pages nest content inside iframes. You might need to switch the IE object's focus to the correct iframe first before accessing the Clear button.

Once you share the full code snippet for the Clear button, we can dive deeper into what's going wrong!

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