|
Dim Myfile As String, ssr As String
Myfile = Dir(ThisWorkbook.Path & "/2012*.xls")
Myfile = Dir
Debug.Print Myfile
ssr = "/名称.xls"
If Application.WorksheetFunction.Search("六合", Myfile) > 0 Then
ssr = "/六合.xls"
ElseIf Application.WorksheetFunction.Search("老莱", Myfile) > 0 Then
ssr = "/老莱.xls"
ElseIf Application.WorksheetFunction.Search("龙河", Myfile) > 0 Then
ssr = "/龙河.xls"
End If
|
|