I have 4 excel files to open during the robot flow:
- First three contain data and need to be updated with add-on.
- The last file is a report file that has formulas connected to first three files.
To create the report, all 4 files need to be open at the same time. That is the cruicial part (to have all files open at the same time), otherwise excel formulas don’t work.
Please suggest best metod to do it.
I already tried:
- EXCEL APPLICATION SCOPE (it closes each file after activities are done)
- START PROCESS (shows error when opening second excel file - “Start process: Application could not be opened”).
Thanks in advance.