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

SQL*XL
home
SQLXL    
  Targets  
    Target

Description:

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.

Example:

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