TempNum/TempNum12
Applies to: Excel 2010 | Office 2010 | VBA | Visual Studio
Framework library function that creates a temporary XLOPER/XLOPER12 containing a Microsoft Excel worksheet number (an IEEE 8-byte double).
LPXLOPER TempNum(double d);
LPXLOPER12 TempNum12(double d);
Parameters
d (double)
The intended value. Note that IEEE sub-normal numbers are not currently supported and are rounded to zero. Negative infinity is supported.
Return Value
Returns a numeric xltypeNum containing the value passed in or zero if the passed in value was sub-normal.
Example
This example uses the TempNum12 function to pass an argument to xlfGetWorkspace.
\SAMPLES\EXAMPLE\EXAMPLE.C
short WINAPI TempNumExample(void)
{
XLOPER12 xRes;
Excel12f(xlfGetWorkspace, &xRes, 1, TempNum12(44));
Excel12f(xlFree, 0, 1, (LPXLOPER12)&xRes);
return 1;
}