How to research Error Handling Messages, Trying to Resolve "Unreadable content" Message

[AlexB123]

Hi all,

I am revamping an old macro that creates a new workbook and then saves to a network location. Although my code works, the file that saves generates a recovery process and message from Excel: "Excel has found unreadable content

in <filename.xlsx>. Do you want to recover the contents of this workbook?" I have found many explanations for this error, but I believe it has something to do with my code. I found the following error handler, because I need to find out specifically what errors are being generated.

I am getting the error numbers, but I am not sure if the output is being sent to some sort of system file, or what I can do to look up the error numbers.

Any suggestions are appreciated.

At the top of my code:

On Error GoTo errHand1
        DivisionByZero = 1 / 0
        Resume Next

errHand1:
    If Err.Number <> 0 Then
     Msg = "Error # " & Str(Err.Number) & " was generated by " _
         & Err.Source & Chr(13) & "Error Line: " & Erl & Chr(13) & Err.Description
     MsgBox Msg, , "Error", Err.HelpFile, Err.HelpContext
     End If
Resume Next

​

​