Hi, i am trying to suppress an error or create my own error event in the case the database is locked. I am using excel to import an external data range, and it autoupdates this lookup. In the case the database is not accessible i want to be able to display my own message. I have tried using the commands
On Error Goto
and
On Error Resume Next
Neither suppress these errors.
Any suggestions?
thanks
Hello GreenFalcon,
Without knowing the error description or number, I would guess it may not be trappable. Most system errors are and respond to methods you have used. Check in your VBA help listing for Errors, Numbers. This will provide you with a list of trappable errors. Repost with the error number and description and code you are using to trap the error, if you still have problems.
Hope this helps,
Leith Ross
Last edited by Leith Ross; 04-18-2005 at 07:06 PM.
thank you i will try to re-produce the error.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks