I know this is easy but can't get this working...
We have multiple Excel 2007 worksheets in separate files, e.g. test file 1, test file 2, etc.
I want to merge all the data from sheet 1 of each file into a new Excel 2007 workbook, sheet 1.
I know this is a module and want to schedule this to run automatically and only update fields with modified and/or new data.