I’m automating executing a macro which opens some excel files and updates its contents (not yet saved). After the macro process, the robot needs to do some checking on the data in those files before saving so I’m using the Excel Application Scope activity and set its ExistingWorkbook property to the file opened. The problem is that, the file is reopened when executing the activity and so the changes are gone. Any idea how to stop this reopening from happening?
I’m thinking of just back up the file before the update > save the changes made by the macro > file is reopened by app scope activity > check the file, and return to the backed up file if the check turns out not good and file should not be saved, but I want to avoid this extra process as much as possible.
Thank you in advance!