error handler causes access to not responding

[davyre]

Hi,

I have this code:

On Error GoTo errHandler
---
exporting to Excel
---
Exit_Sub:
Set rst = Nothing
Set objSheet = Nothing
Set objBook = Nothing
Set objExcel = Nothing
Exit Function

errHandler:
Resume Exit_Sub

end function

so basically in this code, I am trying to create a report in Excel file. The error handler is supposed to handle error when a dialogbox came up asking the location the Excel file will be saved, and if user clicks Cancel in the dialog box, it wont show anything so user will not be confused. This is what user will get if I dont use error handler

can someone tell me what is wrong with my error handler?
*rst is a DAO.Recordset

 

[kjv1611]

1. Wrong forum: you need forum705
2. I do not see anything in your code that does anything other than basic cleanup. Your Error handler does nothing. Yet you say the error handler is causing it.

So either the problem is totally unrelated, or else you're not telling the whole story. Post to the correct forum with enough information, and likely someone will help you find the solution.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57