| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro SaveAs - Date format
I have a european date format ("23-12-06") in a cell, and I am doing my own
saveas in a macro. If I call Application.Dialogs(xlDialogSaveAs).Show, and save it in text, tab-delimited format, I get it in US format ("12-23-06"). There is a local:=True parameter that can be added to ActiveWorkbook.SaveAs method, but can I set this for the Show method, or intercept the save from the Show method and get the filename and format and do it myself? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| my saveas macro date problem | Excel Programming | |||
| workbook saveas function, xlText file format | Excel Programming | |||
| activeworkbook.saveas - saving format changes | Excel Programming | |||
| URGENT - Need date format for SaveAs code | Excel Programming | |||
| Macro to format date | Excel Programming | |||
Threaded Mode
