ALV --> EXCEL BY USING EXCEL ICON ON TOOL BAR

[Former Member]

WHO KNOWS?

THANKS ALOT IN ADVANCE.

[Former Member]

Hi,

The following code snippet will help to achieve this functionality,

CREATE OBJECT LV_ALV_GRID

EXPORTING

I_PARENT = CL_GUI_CONTAINER=>SCREEN0.

CALL METHOD LV_ALV_GRID->SET_TABLE_FOR_FIRST_DISPLAY

EXPORTING

IS_LAYOUT = LT_LAYOUT

CHANGING

IT_OUTTAB = LT_FINAL[]

IT_FIELDCATALOG = LT_FIELDCAT[].

CALL SCREEN 500.

Rgds,

[former_member188685]

Hi amao,

try to set your excel security level to Medium and then see...

open the excel sheet from the menu Tools->Macro->Security-> now here you can see High/Low/medium etc.

change the High to Medium and now check the ALV excel button.

Regards

vijay

[Former Member]

it doesn't work...

[former_member188685]

Hi,

Then in that case you have to Use Local File option(CtrlShftF8) and then Choose Spread Sheet Radio Button , then Ok, and then Enter file name and save.

Regards

vijay