Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
XL2000:
When a open this CSV file through EXCEL normal interface, the files gets correctly formatted when it opens without asking any questions. A date field present is interpreted and formatted as dd-mm-yy. If I record these actions and run then run the macro, the file gets the wrong format in this "date field". It treats the dates as mm-dd-yy! So half of the dates in the file do not get recognized as dates (dates where day 12) Again, this last behaviour only happens if you use the macro to open it. Glad to hear any help! Vasco |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening Files - Macro | Excel Worksheet Functions | |||
Opening Files Using a Macro | Excel Discussion (Misc queries) | |||
show most recent files first when opening excel files | Excel Discussion (Misc queries) | |||
Macro for opening files that changes names | Excel Discussion (Misc queries) | |||
Opening text files using macro | Excel Programming |