HI,
Basically, we can use ReadRangeX activity with UseExcelFile as the following when excel application is running and it opens the file.
If you need to use ReadRangeWorkbook for some reason, workbook property of ReadRangeWorkbook with classic ExcelApplicationScope may help you. In this way, ReadRangeWorkbook doesn’t throw exception even if the file is open.
Sample
Sample20240919-1.zip (9.3 KB)
Regards,