The following code fails, as soon as it gets to an array entry that doesn't have a value: FName = Array("april2010.xls", "feb2010.xls", "jan2010.xls", "july2010.xls", "june2010.xls", _ I'm leaning towards the error handling not skipping an error the way it used to. The Excel itself is also unchanged, but that doesn't mean there hasn't been some upgrade to Office that is making it act differently.
It is failing on files that have been unchanged, are from 2015. It is loading a set of file names into an array, and then reading through them, in order to load data to a database. (Actually, it usually only gives me the option to close or debug the program, but I got the restart option once, on one machine, so that was another point of information.) Windows can try to recover your information and restart the program. This was last run in early October and ran fine. I have an inherited spreadsheet that automatically runs some VBA code and then exits.
0 kommentar(er)
