Hi all, I’m a new learner in UiPath. I am trying to automize my excel template for the daily data reportand, and I have encountered a puzzling problem. Couly you please give me a hand?
Here is the situation:
In an Excel workbook, I click the button (already assigned with Macro script) “Copy SQL Script To Clipboard”. Then I’d like to use UiPath to execute the copied SQL Script. As you konw, next I will use the Funtion “Assign”. Usually, I can just press “Cltrl +V” to paste the script into the blank after “=”
However, the copied SQL Script varies from day to day, and I have to exceute the Script every day.
So how can I make the query execute different scripts without manually pressing “Ctrl+V”?
Maybe it involves the combination of dynamic query assignment and hot key. I’m not sure.
I’ll appreciate if you can offer some suggestions.