Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving txt files and date format changes
Can anyone help me please. I'm trying to save a file as a text file. The
file has the date in a format dd/mm/yyyy. When I save manually it saves in the correct format, but with the following ActiveWorkbook.SaveAs Filename:= _ "c:\myfile.txt", _ FileFormat:=xlText the date format is saved as mm/dd/yyyy, I can't work this out. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving txt files and date format changes
If you're going to import it back into excel, you could use the text to columns
wizard to make sure it's correct (and format the cells after you've imported the file). If you need it for a different purpose, maybe you can steal some code and create your own macro that does it: Earl Kiosterud's Text Write program: http://www.tushar-mehta.com/ Look for Text Write in the left hand frame. Chip Pearson's: http://www.cpearson.com/excel/imptext.htm J.E. McGimpsey's: http://www.mcgimpsey.com/excel/textfiles.html nicoll wrote: Can anyone help me please. I'm trying to save a file as a text file. The file has the date in a format dd/mm/yyyy. When I save manually it saves in the correct format, but with the following ActiveWorkbook.SaveAs Filename:= _ "c:\myfile.txt", _ FileFormat:=xlText the date format is saved as mm/dd/yyyy, I can't work this out. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Highlights & Date Format not saving/displaying correc | Excel Discussion (Misc queries) | |||
Losing date format when saving .csv files | Excel Discussion (Misc queries) | |||
How do i change the date format in a footer for all excel files? | Excel Discussion (Misc queries) | |||
Closing files and saving files | Excel Worksheet Functions | |||
Converting numbers to date format from csv files | Excel Discussion (Misc queries) |