Excel 2007 XLL SDK API Function Reference
This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.
The Microsoft Office Excel 2007 XLL Software Development Kit contains source files for a Framework library that is designed to speed up the writing of XLLs, and three sample projects, Example, Generic, and Stock.
This section provides a function reference for the following:
Excel callbacks that the XLL can call.
XLL callbacks that Microsoft Office Excel looks for.
Key functions in the sample and framework projects.
The Excel 2007 XLL Software Development Kit provides source files and Microsoft Visual Studio 2005 project files for the following sample projects:
The Framework project (SAMPLES\FRAMEWRK\) contains a project that can be built to a library, FRAMEWRK.lib, which can then be linked into other XLL projects. The library contains many functions and tools that make writing XLLs easier. This library is used in both of the other projects in conjunction with the header file FRAMEWRK.h.
The Example project (SAMPLES\EXAMPLE\) contains a project that can be built to an XLL, EXAMPLE.xll. The XLL contains many examples of the use of the Framework library, and example implementations of the XLL add-in interface functions such as xlAutoOpen.
The Generic project (SAMPLES\GENERIC\) contains a project that can be built to an XLL, GENERIC.xll. The XLL demonstrates several example functions and commands and is a good starting point for writing your own XLLs.
The Stock project (SAMPLES\STOCK\) contains a project that can be built to an XLL, STOCK.xll. It also contains an Excel 2007 XLAM Visual Basic for Applications (VBA) macro add-in, STOCK.xlam. The XLL contains functions for the remote polling of data from an imaginary stock price service. The XLAM demonstrates a number of new Excel 2007 features and code that demonstrates the XLL's capabilities.