Hi,
We have an issue with Blue Prism (BP) saving Excel files to a directory that encrypts the file and locks the directory to other writes while the encrypted save completes. If two BP processes attempt to save files in the same directory at the same time, one process will receive a Microsoft Excel prompt indicating that the directory is in use and the save should be tried again later. We need to detect this prompt, click the OK button on the prompt, sleep for a few seconds, and retry the save. The MS Excel VBO.Save Workbook action uses VB.Net to set DisplayAlerts to False and issue the Save command but then freezes while waiting for the Save to complete or fail, which cannot happen until the prompt is dismissed.
I don't know how to detect and dismiss the prompt in the BP code stage that is performing the save. Can anyone help me with a BP code stage that issues the save command but detects and handles this prompt if it appears?
We have an issue with Blue Prism (BP) saving Excel files to a directory that encrypts the file and locks the directory to other writes while the encrypted save completes. If two BP processes attempt to save files in the same directory at the same time, one process will receive a Microsoft Excel prompt indicating that the directory is in use and the save should be tried again later. We need to detect this prompt, click the OK button on the prompt, sleep for a few seconds, and retry the save. The MS Excel VBO.Save Workbook action uses VB.Net to set DisplayAlerts to False and issue the Save command but then freezes while waiting for the Save to complete or fail, which cannot happen until the prompt is dismissed.
I don't know how to detect and dismiss the prompt in the BP code stage that is performing the save. Can anyone help me with a BP code stage that issues the save command but detects and handles this prompt if it appears?