Excel Macro Needed

[kellywiggett]

Hi,

I need to find an excel macro that will traverse through a directory
and it's sub folders looking for workbooks (any .xls files) and
copying the first sheet named "qryExportReporting" contents starting
with column A:2 through E:2 and capturing as many rows that have text
then pasting that data into a different workbook
("AggregateTrainingData.xls") sheet called "Master" that has the same
formatting. I am a complete novice at excel and so far I've found
macros that do part of what I want but I can't get them to work
together to accomplish the whole task.

Any help is greatly appreciated!

Kelly

 

[JP]

Just a helpful suggestion, there is a group for Excel VBA, check it
out:

microsoft.­public.­excel.­programming


HTH,
JP

 

[kellywiggett]

Thank you!

Kelly