Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Microsoft Excel has encountered a problem..."
There is a point where my VBA(Excel XP) code stops executing with the
message "Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience." (Aw! How compassionate!) It happens while initializing an instance of a class called DVrnt, which implements another class called DataField: CODE FROM DVrnt CLASS MODULE: ---------------------------- Option Explicit Option Base 1 Implements DataField private df as DataField .. .. .. ' Initialize the implemented DataField Private Sub Class_Initialize() Set df = New DataField <==== EXCEL DIES HERE End Sub The initialization sub for the DataField class doesn't do anything, and doesn't need to: CODE FROM DataField CLASS MODULE: -------------------------------- Private Sub Class_Initialize() End Sub Yesterday I debugged the whole project that contains this code and it all worked. Then, with no further changes, this behavior started. What can cause this kind of crash, and how is a person supposed to debug it???? Thanks for any tips. (I went through Microsoft's error reporting thing and followed their links hoping for help, but this was unproductive). Ken Dahlberg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel has encountered a problem | Excel Discussion (Misc queries) | |||
Microsoft Excel has encountered a problem | New Users to Excel | |||
Microsoft Excel has encountered a problem... | Excel Discussion (Misc queries) | |||
Microsoft Excel encountered a problem and needs to close | Excel Discussion (Misc queries) | |||
can I bypass "Windows has encountered a problem" | Excel Discussion (Misc queries) |