Failed to Open Excel Worbook [ctx.excel.file.open]

[former_member699645]

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.

[Jerome]

Hello,

There is no other way to open or activate a workbook.

Instead of constantly switching between the open workbooks, I would suggest to create 4 different variables, each one of them being the content of each excel file.

You work with these variables only, and at the very end of your scenario, you write the content in the files.

Regards,

J.