T
Tina
I have an CSV file which contains a date as dd/mm/yyyy hh:mm:ss
When opening the file in Excel from FILE/OPEN the date returns
correctly.(dd/mm/yyyy)
If however I automate this sequence in a macro, the date is returned as
mm/dd/yyyy hh:mm:ss.
My regional setting is set to dd/mm/yyyy.
This has me well and truly stumped.
Opening the CSV in notepad shows the correct format.
When opening the file in Excel from FILE/OPEN the date returns
correctly.(dd/mm/yyyy)
If however I automate this sequence in a macro, the date is returned as
mm/dd/yyyy hh:mm:ss.
My regional setting is set to dd/mm/yyyy.
This has me well and truly stumped.
Opening the CSV in notepad shows the correct format.