PDA

View Full Version : simple loop



eran3185
08-05-2007, 07:03 AM
hi
i have 30 files : *.xls
i want to do a loop that take the 1-200 lines from all the files , and put them in one file
how can i do this thing ?

Simon Lloyd
08-06-2007, 12:15 AM
Check out this kb entry by Malik641 http://vbaexpress.com/kb/getarticle.php?kb_id=829