Option ExplicitPrivate 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
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
你可以建立一个不符合规则的文件夹,这时候系统会提示你名字里不能有哪些字符,然后你判断就行了