Craig,

You can use the copy method like:

ObjExcel.ActiveSheet.Copy(ObjExcel.Workbooks("Target.xls").Sheets("Template"))

where the active sheet is inserted into another file, target.xls, before the sheet "template".


>>>>>>>>>>>>>>> your message below
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?