Private Sub Command1_Click()
debug.print TestFileName ("aa1*.txt")
debug.print TestFileName ("aa1.txt")
End Sub
Private Function TestFileName(strFileName As String) As Boolean
On Error GoTo errHandle
Dim FileNumber As Integer
FileNumber = FreeFile
Open "c:\temp\" & strFileName For Output As #FileNumber
Close #FileNumber
Kill "c:\temp\" & strFileName
TestFileName = True
Exit Function
errHandle:
TestFileName = False
End Function