Is there a way to catch or read the dialog written on an alert? This has been showing sometimes during the execution and I can't catch it with On Error
I also tried using Application.DisplayAlerts = False in the BeforeSave sub but it's still appearing.
My excel VBA workbook is run by an Automation Anywhere bot so I can't just make sure that I have enough space. I just need to handle this alert that pops up when the space is full.
BTW, I also tried checking the disk/folder space first using a vba code but it doesn't work on a shared drive path. It works on a local though.