topic Re: ole excel application from abap in Application Development and Automation Discussions

ole excel application from abap

Former Member — Wed, 27 Dec 2006 06:58:41 GMT

Hi all ,

I an calling one excel application from abap . I don't want to make excel file visible , but insted want to save and close the file , by using method

saveas for excel application and later i want to see the file . file name i want to store in a variable .

eg :

CALL METHOD OF H_EXCEL 'FILESAVEAS' = RC

EXPORTING #1 = filename .

Can it be possible ?

regards,

Former Member — Wed, 27 Dec 2006 08:29:20 GMT

i simpler method will be to use the function modules for this purpose.

CALL FUNCTION 'F4_FILENAME'

IMPORTING

file_name = file_name .

lc_filename = file_name.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = lc_filename

filetype = 'DAT'

TABLES

data_tab = gt_itab.

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Fn module F4_filename will prompt for the name of the file to be saved and GUI_DOWNLOAD will save the file.

gt_itab is the internal table containing the data to be stored in excel.

sourabhshah — Wed, 27 Dec 2006 08:50:23 GMT

hi,

See if this link is useful

Regards,

Sourabh