Excel 2003, problem with UK date format, using OLE
 

Hi all,

I have a C++ package that sends data to a spreadsheet using OLE. The
package works okay in Excel 97 and Excel 2000 systems, but has a
problem with Excel 2003.
In Excel 2003 the "Date" column is not recognised as a date when the
"Locale" is "UK" (left as "General"), but date is recognised okay when
the "Locale" is "US". If I just manually enter the date in "UK" it is
recognised okay.
I have tried formatting the column according to the "Locale"
("MM/DD/YY" or "DD/MM/YY" or "YY/MM/DD") before sending the data, and
leaving it as "General". Both give the same problem.
Can anyone tell me what I'm doing wrong?

Cheers

Bill Dallas

Excel 2003, problem with UK date format, using OLE
 

Hi Bill

I do not have XL 2003 but try formatting the relevant dates with dd/mmm/yy
Excel then usually gets the date correct and the problems of VB being quite
US centric are bypassed.
--
XL2002
Regards

William



"Bill Dallas" wrote in message
om...
| Hi all,
|
| I have a C++ package that sends data to a spreadsheet using OLE. The
| package works okay in Excel 97 and Excel 2000 systems, but has a
| problem with Excel 2003.
| In Excel 2003 the "Date" column is not recognised as a date when the
| "Locale" is "UK" (left as "General"), but date is recognised okay when
| the "Locale" is "US". If I just manually enter the date in "UK" it is
| recognised okay.
| I have tried formatting the column according to the "Locale"
| ("MM/DD/YY" or "DD/MM/YY" or "YY/MM/DD") before sending the data, and
| leaving it as "General". Both give the same problem.
| Can anyone tell me what I'm doing wrong?
|
| Cheers
|
| Bill Dallas