msoFileDialog File Filter XL2003

kpark91

Well-known Member
Joined
Jul 15, 2010
Messages
1,582
Hello,

Is there any way of adding custom filters in msoFileDialog in XL2003?

I've tried using this but it errors on the red line in XL2003.
It works well in XL2007 tho.

Rich (BB code):
Sub cmdBtn1_Click()
 
    ' Requires reference to Microsoft Office 11.0 Object Library.
    Dim fDialog As Office.FileDialog
    Dim varFile As Variant
 
    ' Set up the File Dialog.
    Set fDialog = Application.FileDialog(msoFileDialogFilePicker)
 
    With fDialog
        '.InitialFileName = ThisWorkbook.Path
        ' Allow user to make multiple selections in dialog box
        .AllowMultiSelect = False
 
        ' Set the title of the dialog box.
        .Title = "Please select one file"
 
        ' Clear out the current filters, and add our own.
        .Filters.Clear
       .Filters.Add "sdf (*.SDF)", "*.SDF"
       .Filters.Add "All Files (*.*)", "*.*"
    
        ' Show the dialog box. If the .Show method returns True, the
        ' user picked at least one file. If the .Show method returns
        ' False, the user clicked Cancel.
        If .Show = True Then
            UserMenu.txtTestFilePath.Text = .SelectedItems(1)
        End If
    End With
 
    ' Freeing Object Variables
    Set fDialog = Nothing
 
    If Not loadSettingData(UserMenu.txtTestFilePath.Text) Then _
        MsgBox "The file in the Test File Path does not exist" _
        & " or is not a valid file.", vbCritical
 
End Sub

As always, thank you in advance!
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,224,560
Messages
6,179,519
Members
452,921
Latest member
BBQKING

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top