coverting all *txt files in a folder to formatted .xls files

  • Thread starter Thread starter Adrian
  • Start date Start date
A

Adrian

I have limited experience of macros and I am looking for some help to
automate the following process.

I would like to take a number of *txt files in a folder and convert them
into formatted .xls files in the same location, the delimeter in the files
varies however.

Can anyone help ?
 
Thanks Ron but this doesn't do quiet what I had in mind I would like to take
all of the .txt files in a folder and convert them to formatted workbooks and
save them back to the original source. The code you supplied probably could
have done that but it was too far off for me to modify with my limited
knowledge.
 
Back
Top