I suppose you could , via automation, open or create the Workbook you want everything in. You could then have another Excel instance open up each XLS one by one and use Content.Copy to move data to a new Worksheet "Add"-ed to the new or existing Workbook. I don't see a simpler way to do this. PITA, eh?
>I am creating a report that the client wants sent as an Excel workbook. Each worksheet will contain specific information. I am using Crystal Reports to create each worksheet, then saving it to an XLS file. However, I need to then add each worksheet to the workbook. I can see how to add a new worksheet to the workbook, but how do I then pull the data into the worksheet?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05