VBA; Ignoring On Error commands

[cchristi]

I have 2 two year old Excel and Access applications, and a new Access application, which suddenly have started ignoring the On Error Resume Next & On Error GoTo commands. Within the last 2 months we have upgraded to Access 2002, and within the last month we have been applying the security patches. I had Access reinstalled on Monday. Otherwise, I use DAO.recordsets and have the following references checked.

Visual Basic for Applications
Microsoft Access 10.0 Object Library
Microsoft DAO 3.6 Object Library
OLE Automation
Microsoft ActiveX Data Object 2.5
Microsoft Office XP Web
Microsoft Excel 10.0 Object Library

The error msg is: Object variable or With block variable not set

Help! I am dead in the water until I figure out why it is misbehaving. Thank you in advance. [PC2]

 

[KenReay]

Hi
Could you post the line of code, and maybe the context in which it is happening?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[cchristi]

Thanks Ken,

The following is from my Excel code:

bCloseX = MsgBox("Close Xdisk File", vbYesNoCancel, "CLOSE COMPANY XDISK FILE&quot

Select Case bCloseX
Case vbYes
Windows(FileNbr).Activate
ActiveWorkbook.Close (False)
On Error Resume Next
If Windows(NAICWkbk).Activate = True Then
Windows(NAICWkbk).Close (False)
End If
If Windows(Format(LookUpValue, "00000&quot & "ReptQEx.xls&quot.Activate = True Then
Windows(Format(LookUpValue, "00000&quot & "ReptQEx.xls&quot.Close False
End If
On Error GoTo 0

I use the resume next command several times. This line has been working for 2 yrs. I even changed it to 'on error goto errorhandler' and in the errorhandler I put 'resume next' Same problem.