In one of our processes, there is a need for more Excel modeling than what the MS Excel VBO offers. We needed to model the variations of the "Paste" command.
We have an object that uses various MS Excel VBO stages and then calls upon an object that ...
I am struggling with sending basic Windows commands to any application or browser. I would like to be able to send Windows commands like Ctrl+A, Ctrl+C, and Ctrl+V to any active application without having to model the "Edit" menu. Any suggestions?
Hi Mark,
There is an option in Excel to transpose the data so that the headers are back on top. Could you do this before BP collects the data? To do so in Excel, just select all of the data, right-click and select copy, then either delete your data o...
Hi Christian,
I almost forgot one important step when using hot keys. When stepping through your process while testing, you MUST play through your send key stage; you cannot step through it. Global Send Key commands require that the application has c...
Hi Christian,
At the Object level, use a Navigate stage. The Element will be the top most Element which will be your application. The Action will be ""Global Send Keys"". Your input will be a text command that will look something like ""{CTRL}"". Jus...
Hi Christian,
I currently have a process in production that runs macros in Excel. I used the Global Send Keys commands to call the macros in Excel since each macro can be assigned a hot-key command.
Hope that helps.
Justin
