nicoleheritage
asked on
Excel vba
Hi,
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?
Regards,
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?
Regards,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
nicoleheritage,
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?
KC
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?
KC
ASKER
My starting row is always row 10. Is there a place that I can specify the starting row in the code?