Share via


FileDialogFilters.Add Method (Office)

Adds a new file filter to the list of filters in the Files of type drop-down list box in the File dialog box. Returns a FileDialogFilter object that represents the newly added file filter.

Syntax

expression .Add(Description, Extensions, Position)

expression Required. A variable that represents a FileDialogFilters object.

Parameters

Name

Required/Optional

Data Type

Description

Description

Required

String

The text representing the description of the file name extension you want to add to the list of filters.

Extensions

Required

String

The text representing the file name extension you want to add to the list of filters. More than one extension may be specified and each must be separated by a semi-colon. For example, the argument can be assigned to the string: "*.txt; *.htm".

NoteNote
Parentheses do not need to be added around the extensions. Microsoft Office will automatically add parentheses around the extensions string when the description and extensions strings are concatenated into one file filter item.

Position

Optional

Variant

A number that indicates the position of the new control in the filter list. The new filter will be inserted before the filter at this position. If this argument is omitted, the filter is added at the end of the list.

Remarks

Each filter in a list is made up of two parts: the file name extension (that is, .txt) and the text description of the file name extension (that is, Text Files). Together, the file filter would appear in the Files of type drop down list box as: Text Files (*.txt). Note that when a filter is added to the list, the default filters are not removed. Filters are only displayed when the Windows option is checked. If Position is invalid, an out of range runtime error is displayed. If the Description and Extensions value are invalid, a runtime error (parse) is displayed.

See Also

Concepts

FileDialogFilters Object Members

FileDialogFilters Object