Sub test()
Dim f As String
Dim reg As Object
Dim wb As Workbook
Application.ScreenUpdating = False
Set reg = CreateObject("vbscript.regexp")
With reg
.Global = True
.Pattern = "\d+-\d+-\d+"
f = Dir(ThisWorkbook.Path & "\*.xls")
Do While Len(f) > 0
If f <> ThisWorkbook.Name Then
Set wb = Workbooks.Open(ThisWorkbook.Path & "\" & f)
wb.数据录入.Range("k6") = .Execute(wb.数据录入)(0)
wb.Close True
End If
f = Dir
Loop
End With
Set wb = Nothing
Application.ScreenUpdating = True
End Sub