View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sherry Sherry is offline
external usenet poster
 
Posts: 116
Default 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