Import Wizard settings

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
 
P

Pete_UK

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
 
Top