Opening Excel Spreadsheet from ABAP

[Former Member]

Hello,

Is there any way to put data from an ABAP program into an existing Excel spreadsheet? I know how to put the data into a new spreadsheet but my users want to put the data into an existing spreadsheet where they have developed macros.

Thanks,

Becky

[Former Member]

Hi Becky

Here is a procedure using OLE automation.

DATA gs_excel TYPE ole2_object .
DATA gs_wbooks TYPE ole2_object .
DATA gs_wbook TYPE ole2_object .
DATA gs_application TYPE ole2_object .

CREATE OBJECT gs_excel 'EXCEL.APPLICATION' .
SET PROPERTY OF gs_excel 'Visible' = 1 .
GET PROPERTY OF gs_excel 'Workbooks' = gs_wbooks .
GET PROPERTY OF gs_wbooks 'Application' = gs_application .

*--Opening the existing document
CALL METHOD OF gs_wbooks 'Open' = gs_wbook
     EXPORTING #1 = <file_path_var> .

"*--After this point you can go on processing the sheet
using OLE Automation techniques"

If it is just the template to be stored you can save the template .xls file at the application server each time downloading it to a temporary place to open. Or you can store it at SAP Office templates folder. For SAP Office operations you can inspect "BC_SO_*" masked FMs.

And as a last thing, let me introduce you the SDN forums pointing system: You can assign points to posts you find helpful while solving your question. You can reward points by clicking the yellow star icon at header of each reply post. You can reward;

- one 10 points (solved)

- two 6 points (very helpful answer)

- many 2 points (helpful answer)

Kind Regards...

*--Serdar

[RichHeilman]

You are going to want to look into OLE2 controls.

Check demo program RSDEMO01. I am using 46c.

Good luck,

Rich Heilman

[Former Member]

Hi Rebecca,

you can open the Excel file in append mode, that will help you to retain the previous entries. Then in case of the Macro, i am not sure about that, if i find anything i will let you know.

Regards,

Kathirvel.

[ssimsekler]

Hi Becky

Here is a procedure using OLE automation.

DATA gs_excel TYPE ole2_object .
DATA gs_wbooks TYPE ole2_object .
DATA gs_wbook TYPE ole2_object .
DATA gs_application TYPE ole2_object .

CREATE OBJECT gs_excel 'EXCEL.APPLICATION' .
SET PROPERTY OF gs_excel 'Visible' = 1 .
GET PROPERTY OF gs_excel 'Workbooks' = gs_wbooks .
GET PROPERTY OF gs_wbooks 'Application' = gs_application .

*--Opening the existing document
CALL METHOD OF gs_wbooks 'Open' = gs_wbook
     EXPORTING #1 = <file_path_var> .

"*--After this point you can go on processing the sheet
using OLE Automation techniques"

If it is just the template to be stored you can save the template .xls file at the application server each time downloading it to a temporary place to open. Or you can store it at SAP Office templates folder. For SAP Office operations you can inspect "BC_SO_*" masked FMs.

And as a last thing, let me introduce you the SDN forums pointing system: You can assign points to posts you find helpful while solving your question. You can reward points by clicking the yellow star icon at header of each reply post. You can reward;

- one 10 points (solved)

- two 6 points (very helpful answer)

- many 2 points (helpful answer)

Kind Regards...

*--Serdar

[Former Member]

Hi

I'm using the same technique to run a macro in excel which selects a tab to become active.

However, I need it to save excel & return to SAP, but I'm left in Excel. Do you know how to do this please?

Thanks

Sunni

[eddy_declercq]

Pls also check Thomas Jung Weblogs

/people/thomas.jung3/blog/2005/02/14/bsp-and-microsoft-excel--learning-to-live-together

/people/thomas.jung3/blog/2005/02/23/bsp-and-microsoft-excel--learning-to-live-together-part-2

[Former Member]

The code is below, it leaves me in Excel after running the macro rather than returning to my ABAP??

DATA gs_excel TYPE ole2_object .

DATA gs_wbooks TYPE ole2_object .

DATA gs_wbook TYPE ole2_object .

DATA gs_application TYPE ole2_object .

CREATE OBJECT gs_excel 'EXCEL.APPLICATION' .

SET PROPERTY OF gs_excel 'Visible' = 1 .

GET PROPERTY OF gs_excel 'Workbooks' = gs_wbooks .

GET PROPERTY OF gs_wbooks 'Application' = gs_application .

*--Opening the existing document

CALL METHOD OF gs_wbooks 'Open' = gs_wbook

EXPORTING #1 = 'C:\BOOK1.XLS'.

CALL METHOD OF GS_EXCEL 'RUN' EXPORTING #1 = 'MACRO4'.

FREE OBJECT EXCEL.

???

[Former Member]

Sunni,

may I ask you how do you define your 'MACRO4'?

Is this excel macro or ABAP macro?

Thanks,

Maria