Skip to Content
Former Member
Aug 28, 2012 at 03:36 PM

Inserting OLE Object (specific MS-Excel worksheet)


Dear experts,

in my crystal report I have to insert 3 Excel worksheets in different parts of my report (containing different formatting so i connect them with the OLE option).

So the user would like to edit this in one Excel-file with 3 worksheets. so far so good:

one Excel-file with 3 worksheets

Is it possible to link the OLE-Object to a specific worksheet of my Excel-file like

OLE1: myExcelFile.xls#sheet1

OLE2: myExcelFile.xls#sheet2

OLE3: myExcelFile.xls#sheet3

kind regards