SQL*XL commands can be executed using VBA (Visual Basic for Applications)
coding. This section of the help file explains the SQLXL syntax. Similarly
to Excel VBA programming, the best way to start is to record a macro to see
what code it generates.
Above is the SQL*XL object hierarchy. All code is embedded in the object
SQLXL. If you type SQLXL. (don't forget the
dot at the end) and you do not get a list of available properties and methods
please add a reference to sqlxl.xla to your project. Refer to the Excel VBA
help file how to achieve this.
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.