Excel 10 crashes under Windows 10 after running VBA code

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

Likely the DLLs are using 32bit API calls and Windows10 wants 64bit API calls. Try disabling the references one at a time and see if that stops the error.

You might try disabling events to worksheet change events if that is what is firing the DLL calls. e.g. in the Immediate Window:

Please Login or Register  to view this content.