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 ?
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 ?
Check out this kb entry by Malik641 http://vbaexpress.com/kb/getarticle.php?kb_id=829
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)