Opening CSV File

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
 
P

papou

Hi Paul

Set RecFileFile = Workbooks.Open(FileName:=fRecFile, Local:=True)

This will force Excel VBA to use your regional settings.

HTH
Cordially
Pascal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top