I am trying to create a process that runs an excel macro which pulls back a large amount of data. I am able to get the process kicked off with UIPath, but the original macro creates the data and saves it to the desktop as an xlsx. When the macro finishes it sends back a popup to the screen stating the process is complete. This can take anywhere from 5-10 mins or more to gather all the data. I then need to take the xlsx file, format it with headers/footers/page numbers and mail it as a pdf file.
Once the process gets going I fail on timeOut exceptions.I was trying to do this in a state machine with transitions trying to use a Find Element or On Element Appear. I have also tried just putting it in a flowchart, but I got the same results. I guess I can try and create a huge delay in the process, but would like to use the tool to its best ability. Can anyone provide me some guidance in trying to set this up the right way?