For an automation I need to press on a button in a specific application that opens an Excel file. Within this Excel file I need to change some values, save the Excel file and close it again. Is it possible to use the Excel activities (like Excel Application Scope, Write Cell, Read Range, …) on an already opened Excel? It seems that if you want to use the Excel Application Scope, the Excel file needs to be saved somewhere locally on your computer. Is there a workaround for this?
If not, my workaround was to save the Excel file that opens locally. Use the Excel Application Scope on that file. There I will do all the changes. Then I copy the whole spreadsheet from that Excel (with send hotkeys ctrl+a & ctrl+c) to the Excel that opened in the beginning after pressing on the button.