Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format when opening a .CSV file programmatically
have a date 05/11/2003 in a cell in a csv file
if I open the file manually it reads 05/11/2003 if I open the file via vba it reads 11/05/2003 (if I right click on the cell in all three above cases the format is the same Custom - "dd/mm/yyyy") Any ideas Jason |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format when opening a .CSV file programmatically
What Regional Setting is your computer set to?
dd/mm/yyyy is not US format. Possibly default VBA format used for date is US? Just a guess. Angus Comber "jason" wrote in message om... have a date 05/11/2003 in a cell in a csv file if I open the file manually it reads 05/11/2003 if I open the file via vba it reads 11/05/2003 (if I right click on the cell in all three above cases the format is the same Custom - "dd/mm/yyyy") Any ideas Jason |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date in a .CSV file - IS THIS A BUG??
Angus,
Have you tried this?!!! I've just trued this at home and it looks almost like a bug! Typed 05/11/2003 in A1 and saved it as a csv file. Closed the file and opened it again manually - still 05/11/2003. Opened another workbook and recorded a macro of opening the csv file. Gone back to the recorded macro and run it - now it is 11/05/2003 !!! (still 05/11/2003 when manually opened) Regional settings are set to dd/MM/YYYY. Help. Jason. "Angus Comber" wrote in message ... What Regional Setting is your computer set to? dd/mm/yyyy is not US format. Possibly default VBA format used for date is US? Just a guess. Angus Comber "jason" wrote in message om... have a date 05/11/2003 in a cell in a csv file if I open the file manually it reads 05/11/2003 if I open the file via vba it reads 11/05/2003 (if I right click on the cell in all three above cases the format is the same Custom - "dd/mm/yyyy") Any ideas Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date format problem from opening dbf file in excel 2007 | Excel Discussion (Misc queries) | |||
Disable macros on a programmatically opening .xls file | Excel Discussion (Misc queries) | |||
How to use the exact format in a csv file when opening a csv file | Excel Discussion (Misc queries) | |||
When opening-file format is not valid | Setting up and Configuration of Excel | |||
Opening a csv file with US date format on a Australian PC | Excel Discussion (Misc queries) |