# SetDocumentFilters
{: .no_toc }

Replaces the [**Filter**](/tB/Packages/Contributed/TBMANLIB_Dialog/cDialog/Filter.md) with pairs for office documents.

Syntax: *object*.**SetDocumentFilters**

*object*
: *required* An object expression that evaluates to a **cDialog**.

## Remarks

**SetDocumentFilters** calls [**ClearFilter**](/tB/Packages/Contributed/TBMANLIB_Dialog/cDialog/ClearFilter.md), so any earlier filter is lost, and then [**AddFilter**](/tB/Packages/Contributed/TBMANLIB_Dialog/cDialog/AddFilter.md) for each pair:

| Description | Pattern |
|---|---|
| `Word Documents (*.doc;*.docx)` | `*.doc;*.docx` |
| `Excel Workbooks (*.xls;*.xlsx)` | `*.xls;*.xlsx` |
| `PowerPoint Presentations (*.ppt;*.pptx)` | `*.ppt;*.pptx` |
| `PDF Documents (*.pdf)` | `*.pdf` |
| `Text Files (*.txt)` | `*.txt` |
| `All Files (*.*)` | `*.*` |

The descriptions are fixed English text. To show other text, build the filter with [**AddFilter**](/tB/Packages/Contributed/TBMANLIB_Dialog/cDialog/AddFilter.md). The first pair, Word Documents, is the one that the dialog selects when it opens.

## Example

```tb check_build check_run
Dim dlg As New cDialog
Dim parts() As String
Dim pairCount As Long

dlg.SetDocumentFilters
parts = Split(dlg.Filter, "|")
pairCount = (UBound(parts) + 1) \ 2
Debug.Print pairCount   ' 6
Debug.Print parts(0)    ' Word Documents (*.doc;*.docx)
Debug.Print parts(1)    ' *.doc;*.docx
```

## See Also

- [SetCommonFilters](/tB/Packages/Contributed/TBMANLIB_Dialog/cDialog/SetCommonFilters.md) method -- text files
- [SetImageFilters](/tB/Packages/Contributed/TBMANLIB_Dialog/cDialog/SetImageFilters.md) method -- image files
- [SetCodeFilters](/tB/Packages/Contributed/TBMANLIB_Dialog/cDialog/SetCodeFilters.md) method -- source code files
- [Filter](/tB/Packages/Contributed/TBMANLIB_Dialog/cDialog/Filter.md) property -- the whole list as one string
- [cDialog](/tB/Packages/Contributed/TBMANLIB_Dialog/cDialog/index.md) class -- overview
