It certainly can be done just as @newuserkantu said. But the best option for Office automation is to use VBA (= Word and Excel macros). It is built in directly into Office and free. It is better than anything else. For example UIPath and Automation Anywhere sell Office connectors for a lot of money - you do not need it.
Btw, you can start VBA macros directly from UI.Vision RPA software with the XRUN command. So the integration with UI.Vision is easy.
To use desktop automation you need focus on front of software/page you want use and you can not use mouse because desktop automation move your mouse and works in active part in the screen this is the very disadvantage of desktop automation.
You must have Word or Excel in front and you can not use mouse or other application in front during macro play.
I rarely using desktop automation because I work with multiple browser in same time and for me it’s impossibile to have in front 1 single software/page to use desktop automation.
I’ll have to try the question again with screenshots like you have advised.
Unfortunately, I am even having trouble understanding the commands you have provided me with, it throws an error on the first xClick command. I am using the “find” option to select an image of text box in my word document.
Thanks for your help so far though. I’m just hoping there is some type of solution that is not extremely time consuming once I get this down.
Thanks, I think I should have mentioned that I am just trying to figure out how to open> select text> copy> open another project> paste in the project with any program, not just Word and Excel. I don’t think this will work with a lot of other programs, That’s why I am looking for an RPA that can do this.
Ui vision RPA is a manual software, you must create step by step the automation and this require a long amount of time, for simple operation it’s not convenient to spend a lot of time especially desktop automation takes a lot of time in fact programmers ask for a lot of money to create a desktop automation because it takes too long.
I study about 3 hours a day for 2 years ui vision RPA and I know how to do the automation that you wanted to do, but I can because I studied so much but try to spend time in useful automations that bring gains otherwise it would not make sense to have studied 3 hours a day for 2 years to realize a trivial conversion of documents from word to excel that has no profit and is made online for free in a few seconds.
I mainly use my time to make grabbers of data online or proxy scrapers or custom automatic fillers where there are many things to do (for now I’m making macros to automatically insert wordpress articles)
To realize your automation you have to spend a lot of time for the focus which is the most difficult thing because you have to always have the correct sheet in front of the screen (word or excel), is it worth taking 3-4 hours a day for at least 1 week to realize this automation ? In my opinion, no, you risk taking a lot of time to do something useless that brings no profit and no gain.