Name Excel Workbook

[Former Member]

Hi All,

I am getting some data onto an excel workbook using the below code:

CALL METHOD OF h_excel 'Workbooks' = h_mapl.

SET PROPERTY OF h_excel 'Visible' = 1.

CALL METHOD OF h_mapl 'Add' = h_map.

This workbook will have the name initially as Book1. I want to change this name to something else. How can I do this. I tried

SET PROPERTY OF h_map 'NAME' = 'Hello'.

This didn't work. Can somebody please help me out?

Thanks a lot!!

[Former Member]

Hi All,

I am getting some data onto an excel workbook using the below code:

CALL METHOD OF h_excel 'Workbooks' = h_mapl.

SET PROPERTY OF h_excel 'Visible' = 1.

CALL METHOD OF h_mapl 'Add' = h_map.

This workbook will have the name initially as Book1. I want to change this name to something else. How can I do this. I tried

SET PROPERTY OF h_map 'NAME' = 'Hello'.

This didn't work. Can somebody please help me out?

Thanks a lot!!

[Former Member]

Hi,

Please go through the below link.

http://wiki.sdn.sap.com/wiki/display/ABAP/Sampleprogramtoopenexcelsheetusing+OLE

With Regards,

Sumodh.P