The Target object represents an SQL*XL output target. For example, when a select statement is executed SQL*XL
has to output the data somehow. The target object encapsulates all the details for outputting data into a specific
environment. A Target object is always instantiated by the SQLXL object. The
the Targets property in the SQLXL object to get a reference to a specific target
Encapsulates a Text/CSV file as output target. Use SQLXL.Targets( litText ) to create a reference. If it is not
installed the target will remain empty (Nothing).
No output it required
Set MS Word as output target for a query and specify that no headings should be printed.
SQLXL.SQL.setText Text:="select * from emp"
Set.Target = Targets( litWord )
Note: Please record all code
through the macro recorder.
Copyright (C) 1995-2014 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.