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 Targets

Buy now

Download now

SQL*XL online help


SQL*XL API: Targets Property

Targets Property



The Targets property of the SQLXL object can be used to reference one of the classes that implements functionality for possible output targets. Using predefined constants a reference can be obtained to the objects: litExcel, litWord, litOutlook

In the scenario where queried data is output you should set the properties of the Target object to how you want the output to be handled.


Set the outlook target to send the email directly after putting the data in:

Dim t As Object
Set t = SQLXL.Targets( litOutlook )
t.SendImmediately = True

SQL*XL ribbon in Excel