VBA Changes Date Format of CSV File

[HODY]

Hi all

Having used this site for many years and found it really useful, I am now in need of some more assistance please!

We download a .csv file save it on my C:\ which then needs to be opened and formatted.

I have written a very basic macro to open the file called sgh1.csv.
Code is:
ChDir "C:\"
Workbooks.Open Filename:="C:\sgh1.csv"

The query;
When I open sgh1.csv file normally, via Excel/start it opens up with no problems. All as it should. Date formatting in column F dd/mm/yyyy. (see the first section in green of the attached file)

However... when I run my macro which opens the file, the dates in column F, where possible turn to mm/dd/yyyy ? (see the second section in orange of the attached file)

I can't understand this at all.

Can anybody assist please.

many thanks.

 

[Marc L]

Hi,

post your code between codetags and attach a source csv text file …
​

 

[HODY]

Sorry Marc

This is the code:
[ChDir "C:\"
Workbooks.Open Filename:="C:\sgh1.csv"]

And I've attached two files, sghok.txt that is correct and sghwrong.txt that has been opened via the macro which is wrong.

Thanks.

 

[Marc L]

Working on my side like this :​

    Workbooks.Open "D:\Tests4Noobs\sghok.txt", Local:=True

Do you like it ? So thanks to click on bottom right Like !
​

 

[HODY]

Marc - Awesome!!!

That works a treat.

Many thanks.