VBA to open file using wildcard search WITH CONDITIONS

[kgartin]

SORRY! NEVERMIND! (I can't delete my post!)

 

[6StringJazzer]

If you already have code please show your code. I don't want to rewrite code you already have. I suggest pasting the code, selecting it, and clicking VBA to preserve your code formatting.

 

[6StringJazzer]

If you are using Dir it will be something like this:

Dim FName As String

FName = Dir(FL1-LD*PRESS REPORT*2024-09-05*) 
If InStr(UCase(Fname), "DIG") = 0 Then
   ' Open the file
End If

 

[kgartin]

If you are using Dir it will be something like this:

Dim FName As String

FName = Dir(FL1-LD*PRESS REPORT*2024-09-05*)
If InStr(UCase(Fname), "DIG") = 0 Then
   ' Open the file
End If

Thanks so much man! I tried to delete my post because I figured it out, but I actually like your solution better!! Sweet!

 

[6StringJazzer]

Now you've got me curious about what you did instead.

I made a critical error: That string in Dir has to be in quotes!!

FName = Dir("FL1-LD*PRESS REPORT*2024-09-05*")