Error code information?

The definitive list of error codes is on MSDN: http://msdn.microsoft.com/library/en-us/vbenlr98/html/vamsgtrappableerrors.asp . You will likely, however, need to Google or post a forum message to get detailed information about how to correct specific errors.

Could you identify where in your code the error occurs?

Hi all,
Phil is quite right! I was trying to use my code to open EXCEL when the error occured. I'll try the site that you sugested.

Paul, this is the code where the error occurs:

Private Sub lbl034_Click()
Set AppExcel = CreateObject("Excel.Application")
AppExcel.Workbooks.Open FileName:="g:\tmp\book11.xls"

Cells.Find(What:="34034b", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
'Highlights the entire row.
If IsEmpty(ActiveCell) Then Exit Sub

On Error Resume Next
If IsEmpty(ActiveCell.Offset(0, -1)) Then Set LeftCell = ActiveCell Else Set LeftCell = ActiveCell.End(xlToLeft)
If IsEmpty(ActiveCell.Offset(0, 1)) Then Set RightCell = ActiveCell Else Set RightCell = ActiveCell.End(xlToRight)
Range(LeftCell, RightCell).Select

AppExcel.Visible = True
End Sub

For more information on this problem please see, "Open and close EXCEL with VB6" posted 4-26-06. Several people have tried to help but nothing seems to be working.

Thanks to all, Garner

Yes. When I run the program the code that I use is:
AppExcel.Workbooks.Open FileName:="D:\K and D (152598).xls"
If I try to use the "g:\temp" code I get an error that the file cannot be found. Please see "Open and close Excel with VB6" posted 4-26-06 for ongoing details and help suggested from others. It may explain the situation better without pasting all of the details over to this thread and using up more forum space.
Thank you, Garner

Paul,
Yes, this is confusing. Would it work better this way? To stay with the title of this thread, "Error code information", I'll only ask about that here.

When I get an error code I can usually fix the problem if I know what the code means. I have some books that I can look up some of the codes and there is a definition of what would cause that error. Problem is, I have to search through 3 books about programming to find a code definition scattered among the programming instructions. I was hoping that someone knew of a book or books that only contained error code information arranged in a searchable format. Even if I had to buy seperate books, one for VB6, one for Excel, and one for VBA.

I will post more information on the programming problem under the thread "Open and close Excel with VB6" unless you instruct me to put that information here.

Thank you, Garner

At the risk of sounding really stupid I will tell you that I don't know the name of the worksheet. I opened the "Excel" file that contains my information, clicked Format & then Rename. "Sheet1" was highlighted for renaming. I assumed that "Sheet1" must be it's name? I tried:

Sheet1.Cells.Find(What:="34034b", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate

This generated an "Object Required" error so now I'm guessing that "Sheet1" is not the name of the worksheet? Now I'm totally lost and confused!

Hi again Paul,
I tried everything that you suggested and still the same results. :confused: I am looking over my original code trying to figure out why it will work perfectly the first time and then clicking the exact same label, which should use the exact same code, produces something different. I will post this code in the thread "open and close Excel with VB6" since we are way off the topic of "error code information" which this thread is about.
Thanks for all of the help, Garner