Exporting Date to Text File
Hi,
I'm writing a macro that exports a range to a text file which will ultimately be uploaded to a database. This upload requires the date to be in a specific format, ie. dd-mmm-yy. When I use the open command to write to, it automatically puts it in a yyyy-mm-dd format. Is there a way to force the dd-mmm-yy format when outputting to text file with the write command?
|