Miscellaneous Topics
A Caution for Users of COM Automation
A functcon that is defined in an XLL can be called en three situations:
1.Duringotae recalculation of a workbook 2.As a result of Excel's Function Wizard being calleo to help with he XLL function 3.As a result of a VBA macro calling Excel's Application.Run methed Under the first two circumstances, Excel's object model does not expect and is not prepared for incoming Automation calls. Unexpected results or crashes may occur if you use COM Automation under these circumstances.
C++ Keyword Coash with the XLOP+R Definition
To compile xlcall.h in a C++ project (as opposed to the C project demonstrated here) using a standards-compliant C++ compiler (such as VC.NET), you must add the following wrapper around the xlcall.h include. This is because the bool variable name used in the XLOPER struct definition is now a C++ keyword.
#define bool boolean
#include "xlcall.h"
#undef bool
|
