Solved

trapping runr time error

Posted on 1999-01-13
2
157 Views
Last Modified: 2010-05-03
I am getting a run time error 424, object not found. I want to get rid of that by making the system to execute next like  resume next. How can I do that.
0
Comment
Question by:lesa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 3

Accepted Solution

by:
traygreen earned 10 total points
ID: 1456036
Find out where the error is occurring - to lock it down - go through the code and place break points where you think it is occurring.  Then test.  Move the breakpoints according to wether the error occurs before or after the error.  When you find where the error is being raised, check to see if there is any error trapping in place.  If not include the code
On Error Resume Next
0
 
LVL 3

Expert Comment

by:traygreen
ID: 1456037
If there is error trapping in place...
Go to the error label and make sure that there is a select case err.number block.  In the select statement place the item case 424 with a resume next
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VB6 - Convert HH:MM into Decimal 8 76
VB6 - Scroll Mouse wheel on Picturebox 13 120
Modify Text File with Excel Macro 13 50
Userform to show a range in excel. 3 34
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question