Hello, I am automating a process that needs to open 4 excel files simultaneously, a step was created to read the lines of a spreadsheet to choose which source (there are two options of source files in excel) to copy the information, to paste another excel file.
I am constantly using these steps inside a loop to search for the source (copy) and paste the destination information (final excel file):
- Ctx.excel.file.open (NameSheet);
- Ctx.excel.sheet.activate (WorkSheet);
After a run time, the robot throws this error to open an Excel workbook, its failure to open the Excel workbook.
Is there another way to open or activate the workbook?
Thank you.