importing text file to excel
 

I have several hundred text files. I need to import external data ,fixed
width(default) then finish. I need to save the file as same name as text but
as excel.
Is there any way to do this automatically or with a macro.
I'm not real good with complicated macros.
Thanks
Sherry

importing text file to excel
 

See
http://www.rondebruin.nl/txtcsv.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"sherry" wrote in message ...
I have several hundred text files. I need to import external data ,fixed
width(default) then finish. I need to save the file as same name as text but
as excel.
Is there any way to do this automatically or with a macro.
I'm not real good with complicated macros.
Thanks
Sherry