I'm trying to combine data from several Excel Workbooks (single sheet, identical format, just the number of rows varies) into a new Workbook.
All the "source" workbooks are in a single folder.
In effect I'm trying NOT to Copy and Paste from each one (there's hundreds!) into a Master workbook before going on to process the Master.
I tried downloading "Convert XLS" from SoftInterface, which has a sample of almost exactly what I want to do. Three "blue screen" freezes later I've given up on them.
Can anyone help me to achieve my goal?
All the "source" workbooks are in a single folder.
In effect I'm trying NOT to Copy and Paste from each one (there's hundreds!) into a Master workbook before going on to process the Master.
I tried downloading "Convert XLS" from SoftInterface, which has a sample of almost exactly what I want to do. Three "blue screen" freezes later I've given up on them.
Can anyone help me to achieve my goal?