Thread: Text Import Wizard change default selections
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Russeld Russeld is offline
external usenet poster
  
Posts: 1
Default 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?
Reply With QuoteReply With Quote