topic Launch Excel via Transaction Code in Application Development and Automation Discussions

Launch Excel via Transaction Code

Former Member — Mon, 03 Apr 2006 15:28:28 GMT

I am looking to create a transaction code by which a use can open a new excel workbook. I have seen the function module called RSAH_LAUNCH_EXCEL but i must pass it the workbook name. In my situtation i would like to open a brand new session of Excel. Any suggestions?

Re: Launch Excel via Transaction Code

suresh_datti — Mon, 03 Apr 2006 15:33:53 GMT

Hi,

You can use the function module 'FTBU_START_EXCEL'.

Regards,

Suresh Datti

Re: Launch Excel via Transaction Code

ferry_lianto — Mon, 03 Apr 2006 15:37:08 GMT

Hi Jeff,

Welcome to SDN.

You can go to transaction code OLE and click on Start (Excel) or execute program RSOLETT1.

Also please check this link for sample code.

http://www.guidancetech.com/people/holland/sap/abap/zzbgs700.htm

Hope this will help.

Regards,

Ferry Lianto

Re: Launch Excel via Transaction Code

Former Member — Mon, 03 Apr 2006 15:38:49 GMT

Hi Paolone,

Use the below program to create the Excel sheet from ABAP, this is possible through OLE

REPORT ZCREATEEXCEL.

TYPE-POOLS OLE2.

DATA: EXCEL TYPE OLE2_OBJECT,

WORKBOOKS TYPE OLE2_OBJECT,

WORKBOOK TYPE OLE2_OBJECT.

DATA: FILENAME LIKE RLGRAP-FILENAME.

START THE EXCEL APPLICATION

CREATE OBJECT EXCEL 'EXCEL.APPLICATION'.

PERFORM ERR_HDL.

PUT EXCEL IN FRONT

SET PROPERTY OF EXCEL 'VISIBLE' = 1.

PERFORM ERR_HDL.

INFORM USER OF THE CURRENT STATUS

CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR'

EXPORTING

PERCENTAGE = 0

TEXT = TEXT-I08

EXCEPTIONS

OTHERS = 1.

CREATE AN EXCEL WORKBOOK OBJECT

CALL METHOD OF EXCEL 'WORKBOOKS' = WORKBOOKS.

PERFORM ERR_HDL.

CALL METHOD OF WORKBOOKS 'ADD' = WORKBOOK.

PERFORM ERR_HDL.

EXCEL FILENAME

CONCATENATE SY-REPID '_' SY-DATUM6(2) '_' SY-DATUM4(2) '_'

SY-DATUM(4) '_' SY-UZEIT '.XLS' INTO FILENAME.

CALL METHOD OF WORKBOOK 'SAVEAS' EXPORTING #1 = FILENAME.

FORM ERR_HDL.

IF SY-SUBRC <> 0.

WRITE: / 'OLE ERROR: RETURN CODE ='(I10), SY-SUBRC.

STOP.

ENDIF.

ENDFORM.

*-- End of Program

Thanks

Sudheer

Re: Launch Excel via Transaction Code

Former Member — Mon, 03 Apr 2006 15:53:08 GMT

Hi,

you can use Transaction OLE, and from there you can click on EXCEL.

Regards

vijay