Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting Date to Text File
The Write statement automatically converts date to
universal date format, i.e. the yyyy-mm-dd you are getting. You can force the conversion to another format by using the format function: Format(DateVar,"dd-mmm-yy"). So, for example: Write#1 Var1, Var2, Format(DateVar,"dd-mmm-yy"),... -----Original Message----- 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? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting Date to Text File
Maybe you can write the formatted date:
..... format(myCell.value, "dd-mmm-yyyy")... Dan T wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
Exporting from Excel to a text file | Excel Discussion (Misc queries) | |||
Exporting Text File | Excel Programming |