Close Workbook acitivity doesn't close the open Excel

Help Studio
, ,
1

I am Exporting data from SAP using LIST EXPORTSPHREADSHEET option.
However, after I have downloaded it, the Excel Spreadsheet is being open automatically impeding my process from executing subsequent activities, because the next activity throws an error saying that the “Move File: The process cannot access the file because it is being used by another process.”
So I decided to use the Close Workbook activity by enclosing it in the Excel Application Scope like this:
image
and this is the settings in the property of the Excel Application Scope:

image
image285×502 14.1 KB

And this is the settings in the property of the Close Workbook:
image

Please help me on this. If you know of anyway to download the Excel from the SAP without it opening the Excel please let me know.
Thank you.

2

hi @RobinsonFrancis

if you have used Excel Application scope, once the steps in the process goes out of application scope the excel file would be automatically closed.

If you need to close this excel file before moving. Please try to kill the excel process after exitting out of application scope.

thanks,
aditya

3

Hi @RobinsonFrancis,

We have also faced similar issues while automating a process in SAP.

We kill the excel once the export is completed and this resolved our issue.

I hope it helps