Creating interactive PDF, WORD or EXCEL

[Private_Member_19084]

Hi experts

I have to attach an editable file (interactive PDF, word or excel) to an email.

Is there a way to print a smartform into an interactive PDF, word or excel?

Or creating a word/excel file on another way, without printing-form.

If there is a possibility wo create one of this 3 files, which functionmodules or class can i use.

Thx in advance

Christian

[OttoGold · Accepted solution]

Use http://www.frisoni.com/sap/OLE-Excel.pdf

Otto

p.s.: if you would need any more help on this OLE topic, feel free to ask, I have some experience with that; create a new thread for this

[Private_Member_19084 · Accepted solution]

Thank you again Otto

But I think, this solution can just be done with the frontend.

I need it for the backend.

Because the document should be created and sent, without any user-actions

and on the applicationserver!

Do you also know a solution for this or how I could attach an ole-word-file to an email?

regards

Christian

[OttoGold]

Adobe forms ARE THE SOLUTION. If you have already paid for the licence or that is not your problem and you can use this technology, USE IT! That works in many scenarios:

1) WD scenario/ online - is only one of the many

2) standalone (works even without sap)

3) Offline interactive form <<<----- this is what you want.

I am the Adobe forms senior and can guide you through. Note there is Adobe form forum under NetWeaver - Adobe forms.

Please check this link, what should be the thing you need to:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c2567f2b-0b01-0010-b7b5-977cbf806...

Otto

[OttoGold]

Or try this approach:

http://www.sap2word.de/abap.html

Otto

[OttoGold]

Well, I think you can do it like this: Use the server frontend - run the OLE on the server, save that on the server and when that is finished, you load the file and attach it to the email. And yes, I cannot prove that works and have no coding related to this server side:((

If you would like to use the Interactive Adobe form, I could help you on that too. But note that you have to pay for such a form.

Otto

[Private_Member_19084]

Thx

I think the solution with the serverfrontend is not very good.

What happens, when I create 100 word-files.

Is there no way, to print a smartfrom into a word or excel?, or getting the ole as otf?

AdobeForms are not a solution, because the are just for web-dynpro.

regards and thx

Christian

[OttoGold]

Hello,

if you would like to create a Word file (I mean from scratch, no conversion), you can use ABAP OLE. That is a cool thing.

Check here:

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCFESDE6/BCFESDE6.pdf

http://wiki.sdn.sap.com/wiki/display/Snippets/ABAP-OLEAutomationusing+MS-Word

http://www.scribd.com/doc/7202623/MSWord-Excel-With-ABAP

Regards, Otto

[Private_Member_19084]

Hey

Thank you, this links are great!!!

I can not open the 3rd, because it requires the lates flash-player, which is not installed on my pc.

Can you give me another link or copy the text from the link into your message.

Thx in advance

[Former Member]

hi christian ,

you could refer saptechnical website for adobeforms tutorials . There are a lot of basic exercises to practise.

regards

[Former Member]

Hi,

You could try using Adobe forms , which is an interactive pdf wherin the user can mail to the another user and he can fill the details in the interactive form . you can find many interactive adobe forms in the sdn .

regards

[Private_Member_19084]

Hi

thank you for the fast answer.

How can I create an adobe-form? Which transactions?

regards

Christian