I have a robot that downloads an xls file from a web site. It then opens it with Excel application in order to apply some reformatting. The excel actions are executed inside an Excel Application Scope.
According to documentation and if I’m not wrong, the Excel files are closed when the application scope activity ends. Unfortunately this does not happen every time: there are times when the XLS remain open even after the robot has ended. This problem is more frequent when I run the robot from the Robot Tray rather than from Studio.
I also tried to specify a WorkbookApplication variable, then to explicitly call CloseWorkbook at the end, with no success.
Is there a safe and deterministic way to close Excel at the end of an Application Scope ?