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
object.
Encapsulates a PDF file as output target. Use SQLXL.Targets( litPDF ) to create a reference. If it is not installed
the target will remain empty (Nothing).
Encapsulates a binary XLS file as output target. Use SQLXL.Targets( litXLS ) to create a reference. If it is not
installed the target will remain empty (Nothing).
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).
litNone
Nothing
No output it required
Example:
Set MS Word as output target for a query and specify that no headings should be printed.
SQLXL.SQL.setText Text:="select * from emp"
SQLXL.Targets(litWord).Headings= False
With SQLXL.SQL.Statements(1)
Set.Target = Targets( litWord )
.Execute
End With
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.
sitemap