View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default coverting all *txt files in a folder to formatted .xls files


Look he
http://www.rondebruin.nl/copy4.htm

This is a batch processing macro. You will have to change the text in red
to do what you actually want to do.

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Adrian" wrote:

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 ?
--
Adrian