P
Paul W Smith
I have a problem when opening a CSV file which has a column of dates. The
CSV file has the dates listed as "1/10/2008".
If I open the file directly in Excel, when the file opens the column
displays the dates in UK format as they should be. However if I use the VBA
line below:
Set RecFileFile = Workbooks.Open(fRecFile)
When the file opens the dates as displayed as "10/1/2008" - the US format.
Obviously I need the file to open and read the dates as they are in the CSV
file, i.e. stop the conversion - how do i do this?
PWS
CSV file has the dates listed as "1/10/2008".
If I open the file directly in Excel, when the file opens the column
displays the dates in UK format as they should be. However if I use the VBA
line below:
Set RecFileFile = Workbooks.Open(fRecFile)
When the file opens the dates as displayed as "10/1/2008" - the US format.
Obviously I need the file to open and read the dates as they are in the CSV
file, i.e. stop the conversion - how do i do this?
PWS