Thread: csv to xls date US/UK format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lawler[_2_] Lawler[_2_] is offline
external usenet poster
  
Posts: 4
Default 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?
Reply With QuoteReply With Quote