Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am having a problem with my error trap.
I want to have my error-trap simplydisplay a message and close the data-file that's being used. However, if the error is generated 'late-on' in my macro, the data-file may already be closed, so to handle this, I am usingthe following code: '=========================== Exit Sub ErrorTrap: MsgBox "The Macro has encountered an unforeseen problem" & vbCr & "and cannot continue", vbCritical, "Error " & Err Application.Calculation = xlCalculationAutomatic Err.Clear On Error Resume Next ' in case the sheets are already protected or data file is already closed ' and close the data file DataFile.Close SaveChanges:=False '=========================== but the 'On Error Resume Next ' line seems to be ignored because it generates a standard VB error (with the Debug-box displayed). Is this because I am in an error trap? is there a way around this? thanks M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
how error-trap "no cells were found error" | Excel Programming | |||
Error handling with a handling routine | Excel Programming | |||
On Error doesn't trap Application.Run error | Excel Programming | |||
Error Handler not handling error... | Excel Programming |