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.