I copy a file e twice daily from a server to local drive that I import a table
this is the code I use
Private Sub Form_Open(Cancel As Integer)

Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset
rst.Open "SELECT * FROM tblParameters", CurrentProject.Connection
Forms("Form").bomtxtSource = rst.Fields(0)


Forms("Form").bomtxtCopyTo = rst.Fields(1)
rst.Close

Set fs = CreateObject("Scripting.FileSystemObject")

fs.CopyFile Forms("Form").bomtxtSource & "DEMAND_20100413_003302.csv", _
Forms("Form").bom txtCopyTo & "TES.txt"

End Sub

format of the file name is DEMAND_today date _ time
the time is not allways the same
Is there a wildcard character that I can use instead if 003302
I have used "DEMAND_" & Date &" _003302.csv which works