I can't find Close book activity for Excel

Help Activities
, ,
1

I am opening excel using Excel Application Scope.
Than, I use Save Excel File As activity to save the file with a different name.

At this step, I have opened 2 files.

And, I would need to close the newer file (resulted from Save Excel File As) only, but I could’t find Close Workbook activity in Activities list. I’m using Click activity but, randomly, give me some error ( Excel Application Scope : The Object invoked has disconnected from its clients. Exception from HRESULT : 0x80010108(RPC_E_DISCONNECTED)).

Where should I find Close Workbook activity ?

2

Since you are using excel application scope, when you come out of the scope automatically it will save the file and close the excel sheet.

If you are opening two excel instance, I prefer to use two excel scope so that it will be save accordingly and once the execution is out of scope, the excel will be save and closed automatically.

Hope this works.

1 Like
3

Hi @IPIX ,

Close Workbook activity belongs to Classic Activities, you can use it by enabling “Show Classic” from the Filter.

image

If you are using modern activities , the excel will be Closed Automatically when you use the Scope.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.