View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rbmcclen[_6_] rbmcclen[_6_] is offline
external usenet poster
 
Posts: 1
Default is it possible... (multiple input+naming)


Is it possible to make a macro that inputs all text files from the
directory the workbook is located in and put the files name
(text01.txt) as the first cell of the column the files data is inputed
into? resulting in something like this:

test01.txt test02.txt test03.txt
xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx


--
rbmcclen
------------------------------------------------------------------------
rbmcclen's Profile: http://www.excelforum.com/member.php...o&userid=36367
View this thread: http://www.excelforum.com/showthread...hreadid=563666