nikki333
03-18-2019, 12:41 PM
Hi Folks
I've got this a macro that exports all VBA code to text files as a backup and then imports the newest version from a specific folder. Before the import, it does a backup via saveCopyAs method.
The issue is that at times (quite seldom) I get a message like "Calculation incomplete", asking if I'd like to cancel or complete the calculation. But whatever option I chose, Excel does a fatal crash.
Of notice is that the import/export procedure doesn't allow break-points, which means that even the tiniest issue will lead to an appcrash (as far as I understood).
However, I want to avoid any calculations whatsoever, since they are not at all relevant at this point. I've put an Application.calculatebeforesave = false statement before the savecopyas, but again that seems useless.
Any ideas to prevent these calculations?
I've got this a macro that exports all VBA code to text files as a backup and then imports the newest version from a specific folder. Before the import, it does a backup via saveCopyAs method.
The issue is that at times (quite seldom) I get a message like "Calculation incomplete", asking if I'd like to cancel or complete the calculation. But whatever option I chose, Excel does a fatal crash.
Of notice is that the import/export procedure doesn't allow break-points, which means that even the tiniest issue will lead to an appcrash (as far as I understood).
However, I want to avoid any calculations whatsoever, since they are not at all relevant at this point. I've put an Application.calculatebeforesave = false statement before the savecopyas, but again that seems useless.
Any ideas to prevent these calculations?