topic Export data to Word template in Application Development and Automation Discussions

Export data to Word template

Former Member — Mon, 03 Sep 2007 08:25:28 GMT

Hi,

How exactly do I export data to a Word template? I have a custom program in which data is stored in an internal table. I would like to create an option for the user so that a Word template is opened and the fields are filled with the data from SAP.

For example, transaction FBL5N has this option: File->Export->Word Processing.

I would like to have something like that.

Thanks!

Re: Export data to Word template

Former Member — Mon, 03 Sep 2007 08:59:17 GMT

You can use FM - <b>ALV_WORD_EXECUTE_SIMPLE_LIST</b> for doing this.

You need to pass your internal table to this FM alongwith ur ALV fieldcatalog - and you will be able to export your internal table in the same way FBL1N does.

Cheers.

SKC.

Re: Export data to Word template

Former Member — Tue, 04 Sep 2007 08:53:14 GMT

Thanks.

In the end, I use the FM MS_WORD_OLE_FORMLETTER. I think that FM makes it easier to work with templates.

Another question: in the Word template there are checkboxes. Is there a way to check/uncheck these automatically? Depending on whether a value in the internal table is 'X' or not, for example.

Thanks!

Re: Export data to Word template

Former Member — Tue, 04 Sep 2007 09:13:34 GMT

There is no readymade FM to do that automatically.. for acessing the Form Controls ( like check Boxes,edit boxes, buttons or drop down boxes).

You will have to do that programatically...if u have a look at the FM MS_WORD_OLE_FORMLETTER.. it will give u some idea of doing this... It basically calls the methods of <b>Word.Document</b>. By this object you will be able to access the form objects too ( provided u understand the methods of the Word.Document - u need to some VBA basics.)

Re: Export data to Word template

Former Member — Tue, 04 Sep 2007 10:39:52 GMT

Thanks again. I think I'll leave the checkboxes for what they are then. Maybe I could just replace them by a simple 'X' in the document.