| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incorrect date format
I have some VB6 code that writes a CSV and then uses OLE
to open it in Excel 2002. Somebody has just pointed out that the dates are being interpreted as US format even though the regional settings are for the UK. When I look at the CSV that is written, the dates are OK. If I open that CSV manually it looks fine. But as soon as I use OLE to do the work, the dates get reversed. I'm pretty sure that this has only just started to happen. Has anyone else encountered this ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to reset incorrect date format after reinstalation of Window X | Setting up and Configuration of Excel | |||
| Date Format incorrect | Excel Discussion (Misc queries) | |||
| Number Format Incorrect | Excel Discussion (Misc queries) | |||
| Text File creates incorrect Date format | Excel Discussion (Misc queries) | |||
| day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
![Ric[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
