|
- Sub 复制数据()
- Dim arr, x%
- Dim Na$, Nam$, Wb As Workbook, Sh As Worksheet, Mypath$
- Mypath = ThisWorkbook.Path & ""
- Na = Dir(Mypath & "*.xls")
- Application.ScreenUpdating = False
- Do While Na <> ""
- If Na <> ThisWorkbook.Name Then
- x = Val(Mid(Na, 3))
- arr = Cells(x * 9 - 8, 2).Resize(9, 7)
- Nam = Mypath & Na
- Set Wb = Workbooks.Open(Nam)
- With Wb
- .Sheets(1).[i7].Resize(9, 7) = arr
- .Close True
- End With
- End If
- Na = Dir
- Loop
- MsgBox "复制完毕,共复制:" & x & "组数据!"
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|