Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help VBA SQLXL litErr

Buy now

Download now

SQL*XL online help

 

SQL*XL API: LITErr Object

LITErr Object

SQL*XL
home
SQLXL    
  LITErr  

Description:

The LITErr object is the error handler for SQL*XL. You can use it to control if error messages are displayed or suppressed. 

Properties:

Name Data Type Description
DisplayAlerts As Boolean If set to False, SQL*XL will not display any alert, warning or error message. Default value is True. The logging of error messages in the event log is not affected by this setting.

Example:

Temporarily switch off the error handler:

SQLXL.LITErr.DisplayAlerts = False
'Doing some work where no errors should be displayed
SQLXL.LITErr.DisplayAlerts = True

SQL*XL ribbon in Excel