I’m struggling to find a way to open an excel file in the init workflow, leave it open and then close it at the end, using the excel modern activities.
With the classic ones, I used to create a workbook variable and use as an input of the excel application scope and then use the close workbook activity.
With the modern ones, I can use “Use excel file”, flag the option “keep excel file open” but I don’t find a way to close as I was used before. Do you know why ?
Because I want to be able to open it in the init and leave it open during the execution and not close it and reopen it everytime, especially when I work with heavy excel files.
I just want to know if there’s an option with the modern excel activities to do what I was used to do with the classic ones.
Yes and it has nothing to do with my problem, especially because it’s a topic of 2017 so obviously it doesn’t involve the new excel modern activities.
Are you sure you really understood my problem ? I can provide you more information if you need them.
Thanks and regards,
I don’t want to use start process and open application because like this I cannot use all the modern excel activities, like autofit, get last row etc etc. I would like to know if there’s a corresponding close workbook activity in the modern excel ones.