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
Copyright (C) 1995-2007 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap