Designing Forms with MS Word and MS Excel 
Use
To use the form integration technology, you need both SAPforms and a development environment for electronic forms.
MS Word and MS Excel are examples of such development environments.
It is also possible to create forms in
MS Outlook and
Visual Basic.
In this documentation, it is assumed that you are using Visual Basic. This applies to the application examples in particular.
Prerequisites
You need MS Office 97 or higher.
You need the VBScript Engine 2.0 or higher.
You must
install SAPforms.You should be familiar with the basic functions in MS Word and MS Excel.
Features
SAPforms largely consist of ActiveX components. If you are using the
SAPforms Designer, these components are addressed directly when the form is generated.Unlike Visual Basic, the SAPforms Designer cannot be called as an add-in from MS Word and MS Excel. The SAPforms
Submit control must be used instead.
Activities
Using MS Word
Design a form in MS Word. Use the input fields of the text form fields form (View ® Toolbars ® ...). You can define bindings for these text form fields when you are working with the SAPforms Designer.
Insert a new section.
Use the Control toolbox (View ® Toolbars
® ...) to insert the Submit control in the new section. Choose the Other controls symbol in the SAPforms Submit Control list displayed.
- Choose the Properties entry in the context menu of the control (right mouse click). Choose the property (user-defined) in the following dialog box. The Properties dialog box appears. Choose the SAPforms-Designer pushbutton on the General tab page.
- Edit and generate the form.
- Exit the SAPforms Designer.
- Protect the first section of your document.
- You can now use the form. You can also maintain the document properties with File ® Properties. These properties are also recorded by the SAPforms Designer and can be edited. This means that the form can be used to transfer background data, for example.
Using MS Excel
Design a form in MS Excel. Use the input fields of the named cells form (Insert ® Names® ...). You can define bindings for these cells when you are working with the SAPforms Designer.
- Use the Control toolbox (View ® Toolbars
® ...) to insert the Submit control. Choose the Other controls symbol in the SAPforms Submit Control list displayed.
- Insert the control in the form.
- Choose the Properties entry in the context menu of the control (right mouse click). Choose the property (user-defined) in the following dialog box. The Properties dialog box appears. Choose the SAPforms-Designer pushbutton on the General tab page.
- Edit and generate the form.
- Exit the SAPforms Designer.
- Cancel the block for the named cells and protect the worksheet.
- Exit the draft mode. You can now use the form.
- You can also maintain the document properties with File ® Properties. These properties are also recorded by the SAPforms Designer and can be edited. This means that the form can be used to transfer background data, for example.