Thread: Importing text files into same workbook.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Importing text files into same workbook.
See this example
http://www.rondebruin.nl/txtcsv.htm

--

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


"rkckjk" wrote in message
...
I need to import approx. 25 text files into an Excel workbook from a
directory. Import each text file into a different worksheet of the
workbook. Starting in row 2.

The name of the worksheet should correspond to the name of the text
file.

The records in the text files are delimited bt the pipe"|" symbol.

Thanks

Reply With QuoteReply With Quote