Hi, I am currently using the ReFramework to do the following:
Retrieve current transaction as a DataRow from an Excel file
Find the correct reference Excel file name associated to the row
Write info from the reference file into an output Excel file
Repeat for each other row
In step 3 write cell, I often get an error Workbook was closed by a 3rd party.
What’s making this difficult to debug is that this error occurs randomly and there is no specific data that can be isolated to be causing the error.
How do I debug this?
Hi @DEATHFISH
I haven’t come across this error. But I did find this post, which might help, but not sure…
Excel application scope will close the Excel once it is complete. If it is already closed, it will throw error. So give Continue on error property as true or give Excel application scope inside try catch.
1 Like
Hi, fixed it… apparently I used Close Application instead of Close Workbook to close Excel files and this caused it to detect as external process closing the workbook
3 Likes
system
(system)
Closed
May 3, 2019, 4:18am
4
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.