How to detect when Excel finishes saving a file

Help
1

Hi,

one of our robots is modifying a fairly big Excel file (about 36MB) and saving it to a network folder, more than once during the process. The robot must wait for Save to be finished, before going on with following activities, other wise errors are thrown. Introducing arbitrary delays is not fine, because (a) there is no way to foresee how long each save will be lasting and (b) chooising a “safely” long delay would make the robot last too many hours.
My question is: how can the robot detect when Excel has finished saving the current file ?
Thanks
Pierangelo

2

Hi, are you using excel scope? disable auto save and use a manual save workbook activity, if you have any errors because the file is not released, then you could put in a loop to check for the excel process and wait until it is not running to move on.