import many text files

S

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
 
M

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.
 
Top