Skip to Content
avatar image
Former Member

Creating interactive PDF, WORD or EXCEL

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    Jan 22, 2010 at 11:43 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Jan 22, 2010 at 11:25 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hi christian ,

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

      regards

  • Jan 22, 2010 at 11:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Jan 22, 2010 at 11:53 AM

    Or try this approach:

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

    Otto

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 22, 2010 at 12:01 PM

    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-977cbf80665d

    Otto

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 22, 2010 at 11:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      thank you for the fast answer.

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

      regards

      Christian