XLLQUERY is a command-line tool that examines an XLL add-in and generates a model file which describes the add-in functions it contains. The model file can be used by CWGENCLS.
Usage
| Parameter | Required | Description |
|---|---|---|
| -m ModelFile | Required | The full path and file name of the output file, which will be a model file. |
| -i XllFile | Required | The full path and file name of the XLL to be analyzed. Note that this parameter may be repeated, so that more than one XLL is scanned into the same model file. |
| -e ExcelDir | Required | The directory that contains the desired version of EXCEL.EXE. |
| -t Timeout | Optional | The length of time allowed for Excel to start up and load the XLL addins, in milliseconds. If omitted, the default timeout of 10000 (10 seconds) will be used. |
Location
In the XLL Host installation, XLLQUERY.EXE can be found in the bin\XllQuery sub-directory of the installation folder, e.g. C:\Program Files\Planatech\XllHost\2.0\bin\XllQuery.
The directory will also contain a special version of XLCALL32.DLL, which will be used as a replacement for the standard Microsoft file.
Process
XLLQUERY operates as follows:
- Check that EXCEL.EXE and XLCALL32.DLL exist in the Excel directory, and are valid.
- Rename XLCALL32.DLL to XLCALL32MS.DLL in the Excel directory, and copy the special version of XLCALL32.DLL into the Excel directory.
-
Start the specified version of Excel and use Excel's automation model to open the XLL file or files.
While the XLL files are opened, the special version of XLCALL32.DLL will monitor all function registrations, and save the parameters to a temporary file.
- When the timeout period has completed, close Excel.
- Rename XLCALL32MS.DLL to XLCALL32.DLL in the Excel directory, restoring the original state.
- Transform the temporary file into a model file and save it as specified in the command line.
