| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Import Wizard change default selections
I open a lot of Comma limited files in Excel using the Text Import Wizard.
I need a hack that will pre-set some of the selections in three Wizard steps. In Step 1, I want to default to Delimited. In Step 2, Default to Comma, and in Step 3 I want the Date format to default to YMD. I normally get around this using VB script in the worksheet, but I still would like to change the default settings. Is there a way to set these defaults in Excel or in the Registry? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
| Text Import Wizard: Default File Origin Resolution | Excel Discussion (Misc queries) | |||
| Can you change the Text Import Wizard column options | Excel Discussion (Misc queries) | |||
| Text Import Wizard | Excel Discussion (Misc queries) | |||
| Can you change the settings for an Import Wizard | Setting up and Configuration of Excel | |||
Threaded Mode
