>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=0which I may take as a starting point.
If it's not broken, fix it until it is.
My Blog