The macro language for Excel is called Excel/Visual Basic. Instructions on writing macros in Excel/Visual Basic are contained in a book by Microsoft Press, entitled "Excel/Visual Basic Programmer's Guide." This book contains a complete description of calling ODBC, so it is strongly recommended for anyone who wants to interface Excel to ODBC data sources.
In Excel, the add-in containing the functions necessary to call an ODBC driver is known as XLODBC.XLA. This add-in is installed with Excel when you select ODBC functionality as an installation option. Before trying to access ODBC data from Excel, be sure to install the Excel ODBC functionality.
More: