XLL+ Class Library (6.3)

Function.Versions

Controls which Excel versions the function will support explicitly

Remarks

Versions may have one of the following values:

Excel2003AndBelow Excel 95 to Excel 2003
Excel2007AndAbove Excel 2007 upwards
AllExcelVersions All Excel versions from Excel 95 upwards

This property controls the code that will be generated by XLL+. If Versions is set to AllExcelVersions then two wrapper functions will be generated, one for each environment, and the appropriate one will be registered, depending on which version of Excel is running.

If only one environment is supported then only one wrapper function will be generated. If Excel2003AndBelow is used then the add-in will work in all versions of Excel, but will not take advantage of the new features of Excel 2007 and above. If Excel2007AndAbove is used, then the function will not be available in Excel 2003 and below.

The default value for Versions is controlled by the XLL+ General Options setting DefaultExcelVersions.

See Also

Function Model | Function Properties