>>You can use SaveAs() to save to new file or you can start with new Workbook..
>>
>>>Great code. But as I see in yours and Craig examples, you add new sheets with the informaiton to the first file, e.g. modifying the first Excel file. I was wondering if it's possible to do the same using a new clean file as output and don't touch the files from array?
>
>SaveAs was giving me error :( The resulting code from Craig's procedure produced a file with new name, but the size was 1KB and it was somehow a reference to existing files, because when I deleted them, this new file could not be opened.
>
>I found another link searching UT threads
>http://www.portalfox.com/modules.php?op=modload&name=News&file=article&sid=1029&mode=nested&order=0&thold=0
>
>which I may take as a starting point.

SaveAs is to be used on the workbook and not the Excel application object...

Re: Excel spreadsheets to one workbook Thread #1101620 Message #1102331