Transform a string to year, month and day
static void StringToDateW( const wchar_t* str, int& yy, int& mm, int& dd );
A string containing a date. Excel will use the date formatting rules currently in force to read the string.
Reference to variable which will contain year (eg 1996).
Reference to variable which will contain month (1-12).
Reference to variable which will contain day of month (1-31).
This function calls Excel's DATEVALUE(), YEAR(), MONTH() and DAY() functions to transform a string date into its components.
Because it uses Excel for the transformation, it handles variations in the Excel base date transparently.
If a call to the Excel API fails, then an exception of type CXlApiException will be thrown. Since this exception is derived from CXlRuntimeException, it will be caught by the add-in wrapper function when this method is called from within an add-in function.