I have an Excel 10 SS which does financial modeling. The model has about a dozen tabs, two forms, and six VBA modules containing 5000+- lines of code making very heavy use of large arrays and writes many of these arrays to tabbed sheets. It also uses two external libraries, one a DLL for reading Metastock data files and the other a VBA module for reading Yahoo stock data.
It ran perfectly under Windows 7. I've just switched to a new Win10 laptop on which I've installed Excel 10 and all Windows and Office 10 updates. When I first ran the model, Excel (not VBA) was crashing ("Microsoft Excel has stopped working ... Windows is checking for a solution to the problem") while executing the model. I was able to use breakpoints to identify fact it was crashing in a VBA chart formatting module. I reworked the line of code on which it was crashing and crashes in the chart formatting module ceased. The full model now runs to completion.
However, when I change tabs, Excel crashes ("Microsoft Excel has stopped working ... Windows is checking for a solution to the problem"). This leads me to think that something during execution is destabilizing Excel without causing it to crash. I haven't a clue where to begin looking in my code for that issue. However, the code continues to execute flawlessly under Win7 so I suspect it is an Excel10/Win10 issue.
I'm willing to upgrade to the new Excel 16 but I'm reading that some developers are finding it less than stable with VBA. I could move to Excel 13 but it precedes Win10.
I'm looking for some guidance/ideas in solving the crashing problem. Thank you.
Earl Adamy
Bookmarks