Excel closes unwanted

Help Studio
,
1

Hi, I have a use excel activity with those options:

image

image

I have ‘Save changes’ unchecked, because I don’t want the file to be saved on each writing in it (several data tables must be written to te file), because it slows down the robot too much.

After all data is in the excel file, I use the Save Exel File activity to save the file.
The problem is that the file then closes automatically, but I want to leave it open. What should I do for this to happen?

2

Use Property Keep Excel File Open and Do the activites inside the Use Excel File.

3

We have this option in excel application scope from which you can take a Workbook application type as output and use it later.

Whereas in Modern you have Excel reference.

So i suggest you reopen the excel after this if required.

4

I dont understand why the excel file closes, if this option is checked:

image

5

@TALLIEU_Johan
Hello, put your Excel App Scope inside Use App/Browser Activity which is pointed to Excel app.

Regards

6

can you give some more detail?

7

@TALLIEU_Johan
Put your Excel process inside Use App/Browser activity, properties for that Open: IfNotOpen, Close: Never, when selecting app, have your excel file open and select it for the Use App/Browser

Regards