Use Excel file error issue

Hi @Martins_Micheal

Ensure proper closing:
If using Excel Application Scope, make sure each scope ends properly before a new one starts.

Use different resource names:
In Use Excel File, each time you open a file, give it a different resource name, like Excel1, Excel2, even if it’s the same file.

Reuse the Workbook variable:
If you already have an Excel file open, do not open it again — just use the existing reference.

Check for “Read Only” settings:
If the file is being opened multiple times, set “Read Only” to True if you don’t need to write into it every time.

1 Like