Dim Wb As Workbook, wind As Window, Arr, L As Long
Set Wb = GetObject(ThisWorkbook.Path & "\支出凭证.xlsx")
Set wind = Wb.Windows(1)
Arr = Wb.Sheets("支出凭证").Range("A1").CurrentRegion.Value
wind.Visible = True
Wb.Close True
Set Wb = Nothing
Set wind = Nothing
L = Sheets("支出汇总表").Range("A1048576").End(xlUp).Row + 1
Range("A" & L).Resize(UBound(Arr), UBound(Arr, 2)) = Arr