| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format when using Text Input Wizard and recording a macro
I'm using Text Input Wizard to import a 'fixed width' text file into Excel.
At Step 3 of 3, I change the 'Column Data Format' (specifically 'Date:YMD'). It works ok, but my objective is to get the whole process to work in a macro. Everything works, except the macro doesn't import the date in the format I recorded. Any suggestions? Thanks, Dave H. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro not recording in R1C1 format | Excel Discussion (Misc queries) | |||
| Macro - a way of recording the date | Excel Worksheet Functions | |||
| Recording Time & Date based on data input | Excel Worksheet Functions | |||
| How do I have a macro format cells while recording? | Excel Worksheet Functions | |||
| Excel 97, text box Input Mask, local date format | Excel Programming | |||
Linear Mode
