J
Joe Harman
In the Err_Hand: section you might want to trap the
specific error with an If ... then ... else expression.
Otherwise, you may never know if there is a different
error occurring. In your case, it might not be necessary
but, in general, you'd want to know. For example,
assuming that the error you're expecting is error number
35:
Err_Hand:
If err.number = 35 then
Application.Quit acPrompt
else
msgbox err.Number & " " & err.Description
end if
end sub
Joe
specific error with an If ... then ... else expression.
Otherwise, you may never know if there is a different
error occurring. In your case, it might not be necessary
but, in general, you'd want to know. For example,
assuming that the error you're expecting is error number
35:
Err_Hand:
If err.number = 35 then
Application.Quit acPrompt
else
msgbox err.Number & " " & err.Description
end if
end sub
Joe