| 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 |
| 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) | |||
![nicoll[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
