| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
csv to xls date US/UK format
The following code is designed to copy the whole contents of a small csv file into an excel sheet.
Workbooks.Open Filename:="csvfile.csv Cells.Selec Selection.Cop Windows("xlsfile").Activat Sheets("sheetone").Selec Range("A1").Selec ActiveSheet.Past Windows("gre.csv").Activat Application.CutCopyMode = Fals ActiveWindow.Clos It works fine except when there is a date that is OK in both UK and US formats e.g. 07/11/03 can be either 11th July (US) or 7th November (UK). VB routine defaults to the US format but it works fine doing the procedure manually. Does anybody know the code to default to UK format? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
| How do I convert dd/mm/yy date format to yyddd Julian date format | Excel Worksheet Functions | |||
| change date format dd/mm/yyyy to Julian date format? | Excel Worksheet Functions | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
![Lawler[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
