Adds an ExportFormat object to the ExportFormats collection and returns a reference to the newly created object.
Syntax
object.Add (Key, FormatType, FileFormatString, FileFilter, Template)
The Add method syntax has these parts:
| Part | Description |
| object | Required. An object expression that evaluates to an object in the Applies To list. |
| Key | Required. A unique string that identifies the member of the collection. |
| FormatType | Required. Sets the report type of the object, as shown in Settings. |
| FileFormatString | Required. Sets the text displayed in the Save As combo box of the Export dialog box. |
| FileFilter | Required. Sets the file extension to be used if the user selects the ExportFormat object in Export dialog box. If multiple file filters are used, the first becomes the default extension. |
| Template | Optional. Sets the template to be used for the report. |
Settings
The settings for FormatType are:
| Constant | Value | Description |
| rptFmtHTML | 0 | HTML |
| rptFmtText | 1 | Text |
| rptFmtUnicodeText | 2 | Unicode |
| rptFmtUnicodeHTML_UTF8 | 3 | HTML encoded using Universal Character Set (UTF – 8) |
Return Type
ExportFormat object
Remarks
If you do not specify a Template, Visual Basic supplies a default template appropriate to the FormatType.