merge multiple files from text list of file pairs


I am looking for some examples to get me going on a project to read a
text file which contains in column a and column b file name pairs. I
want to open the two files referred to in a1 and b1, copy a range from
file b1 into a set location in file a1, save a1, close both, then loop
to files a2 and b2 etc. Have about 1000 pairs to loop through so
investing time into getting this to work in an automated fashion would
be great.

Anyone have some examples or ideas regarding the toughest part which to
me is getting the file name pairs, copying code from b to a?

Thanks.

Rob


--
rroach
------------------------------------------------------------------------
rroach's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21093
View this thread: http://www.excelforum.com/showthread.php?threadid=378844

.

Relevant Pages