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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

What is the best way of interacting with MS Office?

Former Member

‎05-21-2004 7:45 AM

0 Kudos

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

‎05-21-2004 1:57 PM

0 Kudos

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

‎06-17-2004 10:30 PM

0 Kudos

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