General information
Category:
COM/DCOM and OLE Automation
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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only