Import Wizard settings

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

I'm importing comma delimited files into excel. I would like to set the
import wizard settings so that it is always "delimited" (rather than "fixed
width") and "comma" (rather than "tab"). Is there a way to do this?

Thanks
Patricia
 
You could record a macro while you do it once and choose the settings
you require for each stage. Then in future you only need to run the
macro.

I think Dave Peterson gave a skeleton outline a few day's ago in
response to a similar request.

Hope this helps.

Pete
 
Back
Top