Using Existing OLE Excel Object

ashok_kumar24 — Mon, 17 Apr 2006 11:24:18 GMT

I have created an ole excel object to download my report data.

My requirement is to use an existing excel object.

Existing OLE object would act like a template with the Header Information and my company's logo in it.

Can anyone suggest suitable procedures for the same.

Re: Using Existing OLE Excel Object

vinod_gunaware2 — Mon, 17 Apr 2006 16:49:24 GMT

I dont know more about it.

Just have look below function module.

EXCEL_OLE_STANDARD_DAT Just calls MS_EXCEL_OLE_STANDARD_DAT

MS_EXCEL_OLE_STANDARD_DATDownloads internal table and opens it in MS Excel

KCD_EXCEL_OLE_TO_INT_CONVERT Uploads an *.xls file to internal table (max cell length = 32).

ALSM_EXCEL_TO_INTERNAL_TABLE the same as KCD_EXCEL_OLE_TO_INT_CONVERT but max cell length = 50

FTBU_START_EXCEL just [download internal table to file and] start Excel (w/o OLE).

regards

vinod