I've upgraded to Excel 2019 and run some fairly basic VBA code on files created in Excel 2010. I'm finding Excel 2019 corrupts my files randomly (I save daily versions of similar files where some data gets scraped from the internet and some is entered by the user). Is anybody else having similar problems? Should I just start from scratch in Excel 2019 and import all the code from the 2010 files?
I receive the following messages: 1st message: "Errors were detected while saving 'C\Users etc...\'. Microsoft Excel may be able to save the file by removing or repairing some features. To make repairs in a new file, click Continue. To cancel saving the file, click Cancel." When clicking Continue repairing doesn't work. Then I get "File not saved" 2nd message: "Can't Find Project or Library" so ALL the macros get deleted.
Thank you all for taking the time to read/respond.