View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan T[_2_] Dan T[_2_] is offline
external usenet poster
 
Posts: 1
Default 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?