Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

What is the best way of interacting with MS Office?

Former Member
0 Kudos
225

Can anyone tell me which is the way to interact with Excel, MS word as far as performance factor is concerned?

Thnx in advance

Balaji

2 REPLIES 2

Peter_Inotai
Active Contributor
0 Kudos
84

I would suggest to take a look at 'Office integration' and 'OLE' nodes in transaction DWDM.

You can find examples there.

Incho

ssimsekler
Active Contributor
0 Kudos
84

Hi!

In our project, we use OLE Automation. You can use OLE2 objects by means of the statements:

INCLUDE ole2incl.

...

DATA x TYPE ole2_object.

...

CREATE OBJECT x 'WORD.APPLICATION' .

SET PROPERTY OF x '<property_name>' = <value> .

GET PROPERTY OF x '<property_name>' = y .

CALL METHOD OF x '<method_name>' = z

EXPORTING #1 =...

#2 =...

...

FREE OBJECT x .

It will be very helpful to inspect code examples of SAP.

*--Serdar