MS Excel / VBA help thread

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

•

Drakien in reply to @aggi
You need to add
```
Local:=True
```
to the
```
ActiveWorkbook.SaveAs
```
bit.

Edit: assuming your PC's regional settings are correct.

•

aggi in reply to @Drakien

I entirely forgot about this. That works, cheers.

@chez_jay I don't disagree with that (also worked with too many Americans) and actually it seems that VBA happily exports in that format. Trying to convince other people is the challenge though.

About

@aggi started