Yes I am using an unattended bot. Tried both and tested attendedly first:
‘Send Window Message’ → Works partly: I can see that “h” and “o” are pressed, but I am not sure if “i” is also pressed, as the dropdown from the ribbon disappears in just a few milliseconds and the columns are still not adjusted. (Without “Send Window Message” it works fine attendedly). I think “Send Window Message” could be the way to go, but something is still wrong here
‘Simulate Type’ → Instant Error message “Cannot use UI_CONTROL_API on this UI node. Please use UI_HARDWAREEVENTS method”
Before run change this settings one time in excel.
In order for this activity to work, Trust Access to the VBA project object model must be enabled from Excel ( File > Options > Trust Center > Trust Center Settings > Macro Settings > Select the Trust Access to the VBA project object model check box).