On error resume next doesn't resume next

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ragtopcaddy - 20 Mar 2008 19:07 GMT

Here's my code:

On Error Resume Next
rs.Close
Set rs = Nothing
wkBk.Close
Set wkBk = Nothing
xlObj.Quit
Set xlObj = Nothing
End Function

Most of the time, the workbook will be closed. My intention is that, if the
wkbk is already closed and/or set to nothing, the next line of code should
execute. It doesn't. Instead I get Run-time error '91' - "Object variable or
With block variable not set" and the code stops at "wkBk.Close". Where am I
going wrong?

Signature

Bill Reed

"If you can't laugh at yourself, laugh at somebody else"

Reply to this Message

Klatuu - 20 Mar 2008 20:32 GMT

In the VB editor:
Tools, Options, General Tab
Be sure Break on unhandled errors is selected

Signature

Dave Hargis, Microsoft Access MVP

> Here's my code:
>
[quoted text clipped - 12 lines]
> With block variable not set" and the code stops at "wkBk.Close". Where am I
> going wrong?

Reply to this Message

ragtopcaddy - 24 Mar 2008 13:40 GMT

Klatuu,

Thanks for the reply. It is already selected. It's puzzling that precisely
the behavior one is trying to avoid by using On Error Resume Next would occur.

Regards,

>In the VB editor:
>Tools, Options, General Tab
[quoted text clipped - 4 lines]
>> With block variable not set" and the code stops at "wkBk.Close". Where am I
>> going wrong?

Signature

Bill Reed

"If you can't laugh at yourself, laugh at somebody else"

Reply to this Message