| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA SAVEAS TXT DATA PROBLEMS
Hi
I have a macro which saves my excel sheet as a text file. There are some cells which include date in dd/mm/yyyy format. When I run thi macro VBA changes the date format into mm/dd/yyyy. This means it reads day as month and vice versa. Any ideas? Thank you very much. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation causing problems when using a data form in Excel 2 | Excel Worksheet Functions | |||
| Problems Obtaining Data | Excel Discussion (Misc queries) | |||
| Problems using SaveAs and SaveCopyAs | Excel Programming | |||
| SaveAs problems | Excel Programming | |||
| Problems with active cell after saveas | Excel Programming | |||
Threaded Mode
