- Sub demo()
- Dim strPath$
- Dim arr, brr, crr
- strPath = ThisWorkbook.Path & ""
-
- Application.DisplayAlerts = False
- Application.ScreenUpdating = False
-
- Workbooks.Open strPath & "2015损益表.xlsm"
- arr = ActiveWorkbook.Sheets(1).Range("D4:P34")
- ActiveWorkbook.Close False
- Workbooks.Open strPath & "2015现金流量表.xlsm"
- brr = ActiveWorkbook.Sheets(1).Range("B5:N8")
- ActiveWorkbook.Close False
- Workbooks.Open strPath & "2015资产负债表.xlsm"
- brr = ActiveWorkbook.Sheets(1).Range("C3:O23")
- ActiveWorkbook.Close False
- Range("D4").Resize(UBound(arr, 1), UBound(arr, 2)) = arr
- Range("T3").Resize(UBound(brr, 1), UBound(brr, 2)) = brr
- Range("T28").Resize(UBound(crr, 1), UBound(crr, 2)) = crr
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- End Sub
复制代码 |