I need to open an excel file and read/write certain info in it. I’m using an excel application scope to do it. However, the issue is, it opens the excel file every time which takes about 2 mins. My process requires to go into the excel file around 50 times a day so this 2 mins adds up.
Is there a way to perform excel application scope activities in an already open excel file? So it does not need to reopen the excel file each time? Currently, the users just keep the excel file open on their desktop all day.