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?

Text Import Wizard change default selections
 

I believe those setting are hard coded into Excel and cannot be
changed.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Russeld" wrote in message
...
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?