Looping through all Workbooks in directory to retrieve rows of information

I have many workbooks in a directory (c:\East\), and I need to copy the same range of cells (A99:BM99) from a specific sheet ("General") and paste them into a file (Master.xls).
So the copied range from the first file in the directory will be pasted in row 2 of master, the copied range from the next file in the directory will be pasted into the next row (row 3), and so on.

Any suggestions?

Thanks!

Hey Fecurtis,

Thanks for the speedy reply, much appreciated.

Nothing seems to happen

Im wondering if it has to do with the destination?

My destination file is c:\East\Master.xls

Yes, it is written right in there, and that is the file that I would want to paste it into. It appears that there is some sort of activity for a split second when I run the macro, but nothing appears in the destination.

Sorry I haven't gotten back to you in a while. I've been trying to figure this out. I know why its not working but can't quite figure out the best way to resolve the issue. The problem is that since Master.xls is located in the same director, the macro will open that and as a result, the additions its made before the reopen event are not saved and you're left with nothing. A few ways around this are:
1. Set Application.DisplayAlerts on True and click "No" when you are prompted to open the same file or not.
2. Use the code below. Its not the most efficient way to run through this. I tried to figure out how to tell the Macro to not even open the excel file if its the same file as thisworkbook but couldn't figure out how to. Perhaps someone on here could:

Please Login or Register  to view this content.