Issue with MS-Excel VBO save Action

[harishpulipati]

Hi All,

We are facing this particular issue while saving Excel Workbook. If there is an unknown window popup arising from the Excel during saving, the process gets stuck doing the save action without throwing any exception (basically trying to save endlessly). How do we handle this?

 

[VJR]

Hi harishpulipati,

In order to handle the issue you will need to mention or even better show screenshots of what is the "unknown window popup" you are referring to.
Also does it appear always during saving or only sometimes.

On which Save action do you receive the popup?
-Save Current Workbook
-Save Current Workbook As
-Save Workbook
-Save Workbook As

What type of file are you trying to Save - an .xlsx or a macro enabled .xlsm workbook?

 

[harishpulipati]

Hi VJR,

we are using "save workbook" action and it is an macro enabled workbook.

We are trying to save the template, if there is a space issue on the drive being saved , it results in a popup.
What we want to achieve is that when this occurs, just throw an exception after trying to save the workbook for a certain point of time.
What actually happens is it endlessly tries to save and doesn't come out of the stage to handle this popup.

Thanks for the response.

 

[VJR]

Hi Harish,

Of course it is not a right idea to perform any save action when there is no disk space.
It looks like due to the space issue Blue Prism does not get the control back from the save action and hence you are unable to throw an exception.
If you are able to spy that pop up and BP detects it then you are lucky, else you would need to write something to identify the disk space if it is below a certain level then do not perform the save action and throw an exception.