Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've got this code:
Sub TimeCTSProcess() Dim sglStartTime As Single Dim sglEndTime As Single Dim sglDuration As Single sglStartTime = Timer Call ProcessCTSWorkbooks sglEndTime = Timer sglDuration = Round(((sglEndTime - sglStartTime) / 60), 2) MsgBox "CTS Eplanning Excel files processed in " & sglDuration & " minutes!", _ vbInformation, "Processing Status" End Sub There is an error handler within ProcessCTSWorkbooks that works fine, however I would prefer than when an error is encountered it would display the msgbox associated with the error handler in ProcessCTSWorbooks and exit the sub. Currently, I get the error message associated with ProcessCTSWorkbooks, AND the message box associated with TimeCTSProcess. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Handling | Excel Discussion (Misc queries) | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Error Handling | Excel Programming | |||
Error handling with a handling routine | Excel Programming | |||
Error Handling | Excel Programming |