MS Excel / VBA help thread

You are reading a single comment by @NotThamesWater and its replies. Click here to read the full conversation.

•

aggi
Anyway, back to shit Excel questions.

Anyone any idea why, if I save a file as a csv using a macro it saves with American format dates? If I save the exact same file manually as a csv it comes out with UK date format.

I'm assuming there is a locale setting I've missed somewhere but I'm fucked if I know where.

Code to save is
```
 ActiveWorkbook.SaveAs Filename:= _
        RootFolder & Chr(j) & h & ".csv", FileFormat _
        :=xlCSVUTF8, CreateBackup:=False
```

•

NotThamesWater in reply to @aggi

How are you looking at the csv file to see what the date is saved as?

•

aggi in reply to @NotThamesWater

A text editor.

Macro saved one has stuff like 3/30/2018 whereas manual saved one is 28/05/2016

About

Avatar for NotThamesWater @NotThamesWater started