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
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:
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:
Code:
On Error GoTo errHand1
DivisionByZero = 1 / 0
Resume Next
Code:
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
