Designing Forms with Microsoft Word and Microsoft Excel
Use
To use
SAPforms Forms, you require a development environment for these forms in addition to SAPforms.
Microsoft Word and Microsoft Excel are examples of such development environments.
It is also possible to create forms in
Microsoft Outlook and Microsoft Visual Basic.
In this documentation, it is assumed that you are using Microsoft Visual Basic. This applies to the application examples in particular.
Prerequisites
You need Microsoft 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 Microsoft Word and Microsoft Excel.
Features
SAPforms largely consists of ActiveX components. If you are using the
SAPforms Designer, these components are addressed directly when the form is generated.
Unlike Microsoft Visual Basic, the SAPforms Designer cannot be called as an add-in from Microsoft Word and Microsoft Excel. The SAPforms
Submit Control must be used instead.
Activities
Using Microsoft Word
Design a form in Microsoft 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. Choose the property (user-defined) in the following dialog box. The Properties dialog box appears. Choose SAPforms-Designer 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 Microsoft Excel
Design a form in Microsoft 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. Choose the property (user-defined) in the following dialog box. The Properties dialog box appears. Choose SAPforms-Designer 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.