Sub Test()
Dim mFile As String
Dim Arr(100) As String
Dim count As Integer
mFile = Dir("D:\data\" & "*.xlsx") '路径
count = count + 1
Arr(count) = mFile
Do While mFile <> ""
mFile = Dir
If mFile = "" Then
Exit Do
End If
count = count + 1
Arr(count) = mFile
Loop
For i = 1 To count
Workbooks.Open Filename:="d:\data\" & Arr(i)
Sheet1.Cells(2, 2) = " " '修改打开文件的内容
ActiveWorkbook.Close savechanges = True
Next
End Sub