OLE Methods Storage Table?

[Former Member]

Hi everyone.

Where my methods related to OLE will be stored? (call method 'ACTIVESHEET' .,)

If you have an ideA,PLEASE post the reply.

Regards,

Kranti .

[Former Member]

Hi Kranthi,

Go through this as it gives you some idea about the where the Function Modules are stored.

http://www.erpgenie.com/abap/code/abap21.htm

I think this may help you.

If this information is helpful the reward me.

Thanks,

Thishya.

[Sandra_Rossi]

I am not sure to understand your question, do you want to know the list of OLE methods that can be called? Answer: refer to the windows software language reference guide (in your case it's EXCEL). "activesheet" is a property of "application" object. See sap documentation http://help.sap.com/saphelp_nw70/helpdata/EN/59/ae3c98488f11d189490000e829fbbd/frameset.htm

Example:

INCLUDE ole2incl.
DATA lole_excel_appli TYPE OLE2_OBJECT.
DATA lole_workbooks TYPE OLE2_OBJECT.
DATA lole_workbook TYPE OLE2_OBJECT.
CREATE OBJECT lole_excel_appli 'excel.application'.
* Next corresponds to VBA: "application.visible = true"
SET PROPERTY OF lole_excel_appli 'visible' = 1.
* Next corresponds to VBA: "set workbook = application.workbooks.open("c:\test.xls")"
CALL METHOD OF lole_excel_appli 'workbooks' = lole_workbooks.
CALL METHOD OF lole_workbooks 'open' = lole_workbook EXPORTING #1 = 'c:\test.xls'.

Instead of direct OLE, you can also use the Desktop Office Integration classes http://help.sap.com/saphelp_nw2004s/helpdata/en/e9/0be775408e11d1893b0000e8323c4f/frameset.htm .

(corrected code) Edited by: Sandra Rossi on Mar 24, 2008 6:09 PM