Outlook VBA Open File Dialog Box

Updated 7 November 2026 · Standard formula, shown below

To open a file dialog box in Outlook VBA, you use the Application.GetOpenFilename method (from the Excel object library) or the FileDialog object from the Microsoft Office object model. The most straightforward approach is to reference the Office FileDialog object, which lets users pick a file and returns the selected path as a string, which you can then use in your code.

Background: Why Use a File Dialog in Outlook VBA?

Outlook VBA is typically used to automate email processing, calendar management, and contact handling. However, many automation tasks also need to read data from external files—such as importing a CSV list of recipients, attaching a file to an email, or processing a text file. The file dialog provides a native Windows interface for the user to select a file, avoiding hard-coded paths that break when the file moves. It also improves usability by letting the user choose the file at runtime, making your macro flexible and user-friendly.

How to Open a File Dialog in Outlook VBA

There are two main methods to open a file dialog in Outlook VBA. The first uses the FileDialog object from the Microsoft Office 16.0 Object Library (or your version’s library). The second uses the Application.GetOpenFilename method, which is part of the Excel object library but can be called from Outlook if you reference it. The FileDialog approach is more native and recommended for Outlook because it doesn’t require an Excel reference.

Here’s a basic example using FileDialog:

Sub SelectFile()
    Dim fd As FileDialog
    Dim selectedFile As String
    Set fd = Application.FileDialog(msoFileDialogFilePicker)
    With fd
        .Title = "Select a file"
        .AllowMultiSelect = False
        If .Show = -1 Then
            selectedFile = .SelectedItems(1)
            MsgBox "You selected: " & selectedFile
        End If
    End With
    Set fd = Nothing
End Sub

In this code, Application.FileDialog creates a file picker dialog. The .Show method displays it and returns -1 if the user clicks Open. The selected file path is stored in SelectedItems(1).

Using the Excel GetOpenFilename Method

If you prefer the simpler GetOpenFilename method, you need to add a reference to the Microsoft Excel Object Library (in the VBA editor, go to Tools > References and check “Microsoft Excel 16.0 Object Library”). Then you can use:

Sub SelectFileWithExcel()
    Dim selectedFile As Variant
    selectedFile = Application.GetOpenFilename("All Files,*.*")
    If selectedFile <> False Then
        MsgBox "You selected: " & selectedFile
    End If
End Sub

This method returns the selected file path as a string, or False if the user cancels. It’s shorter but requires the Excel reference, which some developers avoid to keep their Outlook project lean.

How to Choose the Right Method

Consider these factors when deciding which approach to use:

Dependencies: FileDialog uses the Office object model, which is always available in Outlook. GetOpenFilename requires the Excel library, adding a reference that may not be present on all systems.
Features: FileDialog offers more control, such as setting the initial folder, filtering file types, and allowing multi-select. GetOpenFilename is simpler but less flexible.
Compatibility: If your macro will be shared with others, FileDialog is safer because it doesn’t depend on Excel being installed.
Code readability: GetOpenFilename is more concise, but FileDialog is more self-documenting with its named properties.

Common Problems and Solutions

When using file dialogs in Outlook VBA, you may encounter a few common issues:

Reference not found: If you get a “User-defined type not defined” error, you need to enable the Microsoft Office Object Library in Tools > References.
Dialog doesn’t appear: Ensure your macro is running in the Outlook client, not in a separate application. Also, make sure you’re not in a modal state (e.g., a message box is open).
Multi-select returns array: If you set AllowMultiSelect = True, SelectedItems is a collection; you need to loop through it to get all paths.
File filter not working: The filter syntax for GetOpenFilename is “Description,*.ext”. For FileDialog, use .Filters.Add to add filters.

Comparison: FileDialog vs. GetOpenFilename

Both methods achieve the same goal, but they differ in several ways:

Aspect	FileDialog	GetOpenFilename
Object library	Office	Excel
Multi-select	Yes (AllowMultiSelect)	No (returns single string)
File filters	Customizable via .Filters	Specified in the filter string
Initial folder	Set via .InitialFileName	Not directly available
Return value on cancel	.Show returns 0	Returns False

For most Outlook automation, FileDialog is the better choice because it’s part of the Office library, offers more features, and doesn’t require an external reference.

Safety and Best Practices

When using file dialogs, consider these safety tips:

Always check if the user cancelled: For FileDialog, check if .Show = -1; for GetOpenFilename, check if the return value is not False.
Validate the selected file: Use Dir(selectedFile) to ensure the file still exists before processing.
Handle errors gracefully: Wrap your code in On Error Resume Next or On Error GoTo to avoid runtime crashes if the file is locked or inaccessible.
Be cautious with file paths: If you’re using the selected file to attach to an email, ensure it’s not a temporary file that might be deleted.

Alternatives to File Dialogs

If a file dialog isn’t suitable for your scenario, consider these alternatives:

Hard-coded path: Simple but inflexible; breaks if the file moves.
InputBox: Ask the user to type the full path. Error-prone but works without a dialog.
Folder picker: Use msoFileDialogFolderPicker to select a folder instead of a file.
Drag and drop: Not directly supported in Outlook VBA, but you could use a custom form.

Frequently Asked Questions

Can I use FileDialog in Outlook 2016 or older versions?

Yes, the Office object library has been available since Office 2000, so FileDialog works in all modern versions of Outlook, including 2010, 2013, 2016, 2019, and Microsoft 365.

How do I set the default folder for the dialog?

For FileDialog, set the InitialFileName property to the desired folder path, e.g., .InitialFileName = "C:\Users\Public\Documents". For GetOpenFilename, you can pass the initial path as part of the filter string, but it’s not straightforward.

Can I let the user select multiple files?

Yes, with FileDialog, set AllowMultiSelect = True and then loop through SelectedItems. GetOpenFilename does not support multi-select.

Why does my macro return a file dialog but then nothing happens?

This usually happens when you forget to check the return value of .Show. If the user clicks Cancel, .Show returns 0, and your code should exit gracefully. Also, ensure you’re using the correct variable type for the selected file path.

Is there a way to filter file types, like only .txt files?

Yes, for FileDialog, use .Filters.Clear and then .Filters.Add with a description and pattern, e.g., .Filters.Add "Text files", "*.txt". For GetOpenFilename, use the filter string like "Text files (*.txt),*.txt".

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.