How to allow for "don't care" when getting a file

[Grue42]

Hello!
Maybe this is easy, but I don't know how to search for it.
I have some code that goes looking for a specific filename in a specific format based on some user input.

example: 555_Part_01.01.11_Test.csv

The user would enter "555", "Part", and "Test" - but does not know the date. Excel needs to go open that file.

I currently use:

file_Name = Cells(3, 3).Value + "_" + Cells(4, 3).Value + "_" + ******** + "_" + Cells(5,3) + ".csv"

to make up the file name. Where the asterisks are I need a "don't care" - does Excel VBA has this? (Also, does it have a technical name? I'm sort of an impromptu coder, but I'm trying to learn!)

Thank you!

 

[shg]

Maybe like this:

    Dim sFilt As String
    Dim sFile As String
 
    sFilt = LCase([c3] & "_" & [c4] & "_*_" & [c5] & ".csv")
    sFile = LCase("555_Part_01.01.11_Test.csv")
 
    If sFile Like sFilt Then
        MsgBox "We have a winner!"
    End If

See Help for the Like operator.

 

[Grue42]

Thanks for the help! That did the trick!