Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Just having App_WorkbookOpen crashes Excel
Hi,
I have workbook with an EventClass whose contents are included below. All methods are blank. However, just having those blank templates causes Excel to crash (with 100% consistency) when I try to open a text file a.txt with the following contents: 1 2 3 4 5 6 I get to tell excel how to parse it (Fixed width or Delimited) but when I click Finish, the crash occurs. If the workbook containing this event class is not open, no crash occurs. Opening an excel workbook rather than a parsable text file is no problem. Thank you so much for helping me. Aaron Option Explicit Public WithEvents App As Application Private Sub App_NewWorkbook(ByVal wb As Excel.Workbook) End Sub Private Sub App_SheetActivate(ByVal Sh As Object) End Sub Private Sub App_WorkbookOpen(ByVal inWB As Excel.Workbook) End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel crashes | Excel Discussion (Misc queries) | |||
Excel 200 crashes | Excel Discussion (Misc queries) | |||
Excel XP Crashes | Excel Discussion (Misc queries) | |||
Excel Crashes | Excel Discussion (Misc queries) | |||
VBA crashes Excel | Excel Programming |