Merging spreadsheets

[djeerd]

I have 200 seperate Excel spreadsheets in one folder named "Payroll". Each spreadsheet has data in the range A5:H250. How can I copy all the data ranges in the 200 files into one spreadsheet?

Note: Each spreadsheet has a data filter on the columns so i would need to open each spreadsheet, turn off DATA>FILTER then continue copying.

 

[VoG]

This may get you started http://msdn.microsoft.com/en-us/library/cc837974.aspx