Hi guys I am working on a project and now I have to input a excel query formula (someone written for me) into the advanced editor. I have tried using the “type into” activity but the robot cannot detect the UI element and stuck. Is there any other ways to do it?
I want to remove the existing formula and have mine inputted inside. The below picture is an illustration.
@Komom
If the “Type Into” activity fails, try “Set Text” to input your formula directly. Alternatively, use “Set to Clipboard”, then “Send Hotkey” (Ctrl + A, Ctrl + V) to replace the text.
enable “Simulate Type” or “Send Window Messages” in “Type Into.” Ensure the editor is active before inputting text. You can also try “Click” before typing. If needed, use “Anchor Base” to improve UI selection.
cheers!!
Thx for your reply! But the robot seem to cannot detect anything in the popup dialogue box at all. I have tried many methods still cant work.
Use Use Application Browser activity indicate this popup window. Inside this use Type Into activity to type the desired query.
