import many text files

[Serge]

I have to import text files in Excel. I'd like to bypass
the procedure of "lines to skip" and "Delimiter
Selection" since it's always the same.

Is there a way to tell Excel how to import a certain type
of file (regarding the extention) and to do it without
asking questions ?

Thank you

 

[Mark]

If your text files are comma delimitered, then changing
the file extension to .csv rather that .txt will cause
Excel to open your text file without going through the
import wizard.