Monthly Rollup of data

[singlgl1]

I'm gonna try to word this so that it makes sense so forgive me if I fail to do so.
I have a daily file that contains a sheet named "events" that captures gas volumes vented throughout the day.The files are named 6-1-11, 6-2-11,etc throughout the month.Some days may have no events and some may have one or more.There are rows on each daily sheet for up to 21 events during the day(cells A5:T25 ). Now what I would like to do is rollup each event onto one "monthly" sheet in a separate workbook at the end of the month.I'd like to tell it to go and look at each of these files for the month (6-1-11,6-2-11, and so on and look at sheet "events" and pull in only the info on rows A5:T25 where the corresponding cell in column A is populated.I'm assuming this wouyld be some kind of lookup function but need some guidance from the pros out there.
I appreciate any feedback and will provide files and more info if necessary.
Thanks Again !!

 

[pbornemeier]

To get make the code always choose to not update links (and hopefully get rid of the links question) , change this line:
Workbooks.Open Filename:=strFileName
to this:
Workbooks.Open Filename:=strFileName, UpdateLinks:=False

For XL2007 it should be:
Workbooks.Open Filename:=strFileName, UpdateLinks:=2

One way to debug would be to put a Stop statement after each loop. The code will stop there. Then pressing F8 will execute one line at a time or F5 will continue execution.

Did the summary message pop up at the end? If you got into a routine hitting enter to answer the links question, you may have acknowleged it when it popped up without noticing what it said.