Results 1 to 4 of 4
  1. #1
    Hpool2018 is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Apr 2019
    Posts
    10

    Application.FileDialog add filters using a string

    is there a way to add filers to fileDialog from a string?

    Public Function OpenDialogBox(Dtype As DialogType, Optional tTitle As String, Optional filters As String) As String
    Dim Ffilter() As String
    Dim i As Integer
    Dim SplitFilters() As String

    Set fileSysObject = Application.FileDialog(Dtype)

    With fileSysObject



    If Len(filters) > 0 Then
    Ffilter = Split(filters, ";")
    .filters.Clear
    If UBound(Ffilter) > 0 Then
    For i = 0 To UBound(Ffilter)
    SplitFilters() = Split(Ffilter(i), ",")
    .filers.Add SplitFilters(0), SplitFilters(1)
    .FilterIndex = (i)
    Next
    End If
    End If

    If Not IsNull(tTitle) Then .Title = tTitle

    .Show
    OpenDialogBox = .SelectedItems(1)
    End With

    End Function

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870

  3. #3
    Hpool2018 is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Apr 2019
    Posts
    10
    Thanks, had a look and does not cover what Im trying to do, Cheers

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    I'm not sure of your exact requirement.
    I have a routine that calls a function
    Code:
    Public Function OpenFileDialog( _
        DisplayText As String, FilterText As String, ParamArray Filter() _
             ) As Variant '// Ref required:= Microsoft Office 11.0 Object Library '// return an array of selected items, ToUSe:
          '// ItemArray() = OpenFileDialog("Please Select...","Images","*.gif","*.jpg","*.png","*.bmp")
          Dim fd As FileDialog
          Dim vrtSelectedItem As V......
    routine
    Code:
    Sub test_filepicker()
    
          Dim itemArray() As String
    10       On Error GoTo test_filepicker_Error
    
    20    itemArray() = OpenFileDialog("Please Select...", "Images", "*.gif", "*.jpg", "*.png", "*.bmp", "*.txt")
    
    30       On Error GoTo 0
    40       Exit Sub
    
    test_filepicker_Error:
    
    50        MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure test_filepicker of Module Module5"
    End Sub
    When I try to run test__filepicker with filters such as "D*.jpg" I get an Error 5 invalid procedure call or argument.
    So my suspicion is you can only use *.extension or *.*.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 03-07-2016, 07:11 AM
  2. Replies: 2
    Last Post: 02-27-2016, 10:59 AM
  3. Replies: 1
    Last Post: 08-27-2015, 06:05 AM
  4. FileDialog with filters
    By fritesmodern in forum Programming
    Replies: 6
    Last Post: 05-08-2015, 08:28 AM
  5. FileDialog
    By Tomfernandez1 in forum Programming
    Replies: 9
    Last Post: 04-13-2011, 03:45 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums