Open all worksheets in a specific folder

Hi. As FileSearch doesn't work in Office 2007, I am trying to use royUk's code (see below) to copy cells from workbooks in a directory to one summary worksheet. The code works perfectly to step through the files in the directory and allows me to copy one cell at a time from the opened workbook to my summary workbook, but I can't get it to copy more than one cell at a time per line of code.

I would like to also copy a fixed range A13:J27 from each opened workbook to cells Ax:Jx (where x will increment by 14 each time) on my summary sheet in one go and not have to copy that range cell by cell. Is this possible?

Please Login or Register  to view this content.

Any help will be greatly appreciated.
Thanks,
Bruce

Hi
try the following modifications

Please Login or Register  to view this content.

if it does not work, Change the file path in the second macro posted in the following link
http://www.mrexcel.com/forum/showthr...ight=file+open
and the run the macro
Ravi

Thanks Ravi. Will give it a go and get back to you.
Bruce

Thanks Ravi, that does what I need. Below is the code - slightly modified - I ended up with to increment the row number on each loop so that the next A13:J27 range copied is pasted into the next blank row down.

Please Login or Register  to view this content.

Much appreciated!
Bruce