Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
on error in whole workbook ?
Hi,
I have so much code that i would like to know if there is an 'on error' possible that would work throughout all the codes and subs in the application. On error, i would like to know what the error is and then close the application. Any ideas? thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200510/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
on error in whole workbook ?
Sub test()
On Error GoTo error_handler '' do your stuff Exit Sub error_handler: MsgBox "An error occured in test. " & vbCr & Err.Description & vbCr & Err.Number Err.Clear Application.DisplayAlerts = False Application.Quit End Sub Greetz, Rody "Pierre via OfficeKB.com" <u13950@uwe schreef in bericht news:567ae48b77ed6@uwe... Hi, I have so much code that i would like to know if there is an 'on error' possible that would work throughout all the codes and subs in the application. On error, i would like to know what the error is and then close the application. Any ideas? thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200510/1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
on error in whole workbook ?
thanks Rody !
Works fine. Pierre Rody Meulman wrote: Sub test() On Error GoTo error_handler '' do your stuff Exit Sub error_handler: MsgBox "An error occured in test. " & vbCr & Err.Description & vbCr & Err.Number Err.Clear Application.DisplayAlerts = False Application.Quit End Sub Greetz, Rody Hi, [quoted text clipped - 7 lines] thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200510/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error - No more new fonts in this workbook | Excel Discussion (Misc queries) | |||
Link to another workbook error | Excel Discussion (Misc queries) | |||
error when using variable name for workbook | Excel Programming | |||
Error when Open WorkBook | Excel Programming | |||
Workbook reference error | Excel Programming |