Thread
:
Opening CSV File
View Single Post
#
2
Posted to microsoft.public.excel.programming
papou[_4_]
external usenet poster
Posts: 110
Opening CSV File
Hi Paul
Set RecFileFile = Workbooks.Open(FileName:=fRecFile, Local:=True)
This will force Excel VBA to use your regional settings.
HTH
Cordially
Pascal
"Paul W Smith" a écrit dans le message de news:
...
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
Reply With Quote
papou[_4_]
View Public Profile
Find all posts by papou[_4_]