Hey guys!
I have this macro to save excel files as tab delimited files with the datum as name which is in cell B2.
Sub speichernalstxt()
'
' speichernalstxt Macro
'
' Keyboard Shortcut: Option+Cmd+b
'
Range("O221").Select
ActiveWorkbook.SaveAs Filename:= _
"Macintosh HD:Users:stefandittmann:Desktop:Test:" & Range("B2").Value & ".txt", FileFormat _
:=xlText, CreateBackup:=False
Range("O221").Select
ActiveWindow.Close
End Sub
It workes really nice but it alway changes the format of the datum within the files from dd/mm/yy into mm/dd/yy. How can I stop that?
Thanks heaps!
Bookmarks