Excel vba


I have multiple (not sure how many) excel files at this location (C:\My Documents\02a Parent folders). I want to open each file and copy records starting from row 10 until the end (the end point will differ for each workbook) into a new master file.
This process needs to be repeated for all the files under the folder and "appended" to the master file so that at the end the master file will contain all the records
Can someone please provide me the vba code which can do this?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Patrick MatthewsCommented:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nicoleheritageAuthor Commented:
Wonderful code.
My starting row is always row 10. Is there a place that I can specify the starting row in the code?

Need some more clarification as to the problem.  Do all the expected excel files in the  location (C:\My Documents\02a Parent folders) have consistent extension such as .xlsx, .xls, etc and will each workbook just have one tab/worksheet of data containing the data needed to be copied and appended to the master file?  

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.