I have been struggling now for a few days, so time to ask the experts. My
problem is this;
I have 46 txt files each in exactly the same format and layout each with
different file names,
I need to be able to open all the files in th efolder Without specifying file
names,
Then to be able to extract the 3rd and 46th line from each txt file,
I then want to paste these 2 lines into a workbook leave a space and then
paste the next 2 lines and so on,
and finally the two lines will need formatted to "text to columns\fixed width\
can anyone help?
many thanks
David
--
Message posted via http://www.officekb.com
Bookmarks