Sub 名称()
Dim arr, brr(), i
arr = Range("A2:A" & [A666].End(3).Row)
For i = 1 To UBound(arr)
Application.ScreenUpdating = False
Set wb = Workbooks.Open(ActiveWorkbook.Path & "\" & arr(i, 1) & ".xlsm", , True)
ReDim Preserve brr(1 To UBound(arr), 1 To 1)
brr(i, 1) = wb.Sheets("Sheet1").Range("B2")
wb.Close False
Application.ScreenUpdating = True
Next
Range("B2").Resize(UBound(brr), 1) = brr
End Sub