'作者: Thierry Waty'作者主页: http://www.geocities.com/ResearchTriangle/6311/'这是一个根据错误代码直接从系统中得到错误描述的程序，你可以不要用硬编码了
'使用举例:
' Call APIError
' *** Or ' Debug.Print ReturnAPIError(53) ' *** Return : 网络适配器硬件出错。
' #VBIDEUtils#************************************************************' * Programmer Name : Waty Thierry' * Web Site : www.geocities.com/ResearchTriangle/6311/' * E-Mail : waty.thierry@usa.net' * Date : 12/10/1998' * Time : 20:20' * Module Name : APIError_Module' * Module Filename : APIError.bas' **********************************************************************' * Comments :' * 这是一个根据错误代码直接从系统中得到错误描述的程序，你可以不要用硬编码' *' *' **********************************************************************
Option Explicit
Private Const FORMAT_MESSAGE_FROM_SYSTEM = &H1000Private Const FORMAT_MESSAGE_IGNORE_INSERTS = &H200
Private Declare Function FormatMessage Lib "kernel32" Alias "FormatMessageA" _ (ByVal dwFlags As Long, lpSource As Any, ByVal dwMessageId As Long, _ ByVal dwLanguageId As Long, ByVal lpBuffer As String, ByVal nSize As Long, _ Arguments As Long) As Long
' *** Status CodesPrivate Const INVALID_HANDLE_VALUE = -1&Private Const ERROR_SUCCESS = 0&
Public Function ReturnAPIError(ErrorCode As Long) As String ' #VBIDEUtils#************************************************************ ' * Programmer Name : Waty Thierry ' * Web Site : www.geocities.com/ResearchTriangle/6311/ ' * E-Mail : waty.thierry@usa.net ' * Date : 12/10/1998 ' * Time : 20:21 ' * Module Name : APIError_Module ' * Module Filename : APIError.bas ' * Procedure Name : ReturnAPIError ' * Parameters : ' * ErrorCode As Long ' ********************************************************************** ' * Comments : ' * Takes an API error number, and returns ' * a descriptive text string of the error ' * ' **********************************************************************
Dim sBuffer As String
' *** Allocate the string, then get the system to ' *** tell us the error message associated with ' *** this error number sBuffer = String(256, 0) FormatMessage FORMAT_MESSAGE_FROM_SYSTEM Or FORMAT_MESSAGE_IGNORE_INSERTS, 0&, ErrorCode, 0&, sBuffer, Len(sBuffer), 0&
' *** Strip the last null, then the last CrLf pair if it exists sBuffer = Left(sBuffer, InStr(sBuffer, vbNullChar) - 1) If Right$(sBuffer, 2) = Chr$(13) & Chr$(10) Then sBuffer = Mid$(sBuffer, 1, Len(sBuffer) - 2) End If
ReturnAPIError = sBuffer
End Function
Public Sub ApiError() ' #VBIDEUtils#************************************************************ ' * Programmer Name : Waty Thierry ' * Web Site : www.geocities.com/ResearchTriangle/6311/ ' * E-Mail : waty.thierry@usa.net ' * Date : 12/10/1998 ' * Time : 20:35 ' * Module Name : APIError_Module ' * Module Filename : APIError.bas ' * Procedure Name : APIError ' * Parameters : ' ********************************************************************** ' * Comments : ' * Takes an API error number, and returns ' * a descriptive text string of the error ' * ' **********************************************************************
Dim sError As String On Error GoTo ERROR_APIError sError = InputBox("Enter the error number", "Returns API error") If IsNumeric(sError) = False Then Exit Sub MsgBox ReturnAPIError(CLng(sError)), vbInformation + vbOKOnly, "Error n " & sError Exit Sub ERROR_APIError: MsgBox "Error n " & sError & vbCrLf & " Invalid error number" & vbCrLf & "You have to give another one", vbCritical + vbOKOnly, "Error n " & sError End Sub
