Text Import Wizard change default selections

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Russeld - 31 May 2006 20:15 GMT

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?

Reply to this Message

Chip Pearson - 31 May 2006 23:08 GMT

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

Signature

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

>I open a lot of Comma limited files in Excel using the "Text
>Import Wizard".
[quoted text clipped - 9 lines]
> set these
> defaults in Excel or in the Registry?

Reply to this Message