In one of my workflows I can find a specific value on a website by using a series of Send Keys commands (using tabs etc to get the mouse where I want it). I can also select the data I want to copy using Send Keys {Shift}({Right}) to select the data immediately to the right of the mouse. MANUALLY, I can copy the selected data (Control+C) and paste it in Excel.
However, If I try to automate the copy step of this flow, using Send Keys {Control}({C}), for some reason the selected data is not copied to the clipboard, so I cannot use Get Clipboard Data to later paste it in Excel.
How can I solve this? Please note that UI Elements are often not recognized so looking for another way to achieve the copy step.