I have a VBA add-in that works fine on lots of different Windows PCs.
Recently, several users reported that the add-in shows the following message numerous times, one after another, when trying to load either as an application add-in file or via the source macro-enabled Office file:
System Error &H8000FFFF (-2147418113). Catastrophic failure
Microsoft's help page that this message links to simply states "Visual Basic encountered an error that was generated by the system or an external component."!
After repeatedly clicking OK or or holding the Enter key to dismiss this repeating message, the following message is eventually displayed:
Compiler error. Out of memory.
I have issolated it to a specific model of Dell XPS laptop but they are well spec'd with Windows 10 Pro 64 bit, 16GB RAM and 2.2 GHz Intel Core i7.
The project has many modules/userforms/classes so it's not possible to post all of the code here, or even easily issolate where it's going wrong due to the nature of the error messages and behaviour of VBE after dismissing them.
Once out of the error message loop above, the following text in bold is highlighed in a code moule window:
Optional ByVal CompareMode As VbCompareMethod = vbTextCompare
Public Function QSortInPlace( _
ByRef InputArray As Variant, _
Optional ByVal LB As Long = -1&, _
Optional ByVal UB As Long = -1&, _
Optional ByVal Descending As Boolean = False, _
Optional ByVal CompareMode As VbCompareMethod = vbTextCompare, _
Optional ByVal NoAlerts As Boolean = False, _
Optional ByVal tSeparator As String = "") As Boolean
Given the compexity of the project, how can I proceed in working out what is wrong?