|
- Sub 导入()
- Dim Wb As Workbook '定义Wb为工作簿对象型变量
- Dim MyPth As String '定义MyPth为文本型变量
- Dim arr()
- Application.ScreenUpdating = False '关闭屏幕刷新
- MyPth = ThisWorkbook.Path & "\学生基本信息.xls" '把数据源工作簿路径赋给MyPth
- Set Wb = GetObject(MyPth) '把返回路径上的文件引用且赋值给Wb
- With Wb
- ReDim arr(1 To Wb.Sheets.Count, 1 To 76)
- For k = 1 To Wb.Sheets.Count
- With Wb.Sheets(k)
- arr(k, 1) = .Range("d19") & .Range("d20")
- arr(k, 2) = .Range("d5")
- arr(k, 3) = .Range("d6")
- arr(k, 4) = .Range("h5")
- arr(k, 5) = .Range("h6")
- arr(k, 6) = .Range("d10")
- arr(k, 7) = .Range("d7")
- arr(k, 8) = .Range("h17")
- arr(k, 9) = .Range("h18")
- arr(k, 10) = .Range("d18")
- arr(k, 11) = .Range("d15")
- arr(k, 12) = .Range("d9")
- arr(k, 13) = .Range("h14")
- arr(k, 14) = .Range("h19")
- arr(k, 15) = .Range("h20")
- arr(k, 16) = .Range("d14")
- arr(k, 17) = .Range("d9")
- arr(k, 18) = .Range("d8")
- arr(k, 19) = .Range("d22")
- arr(k, 20) = .Range("d23")
- arr(k, 21) = .Range("h22")
- arr(k, 22) = .Range("d25")
- arr(k, 23) = .Range("h23")
- arr(k, 24) = .Range("h24")
- arr(k, 25) = .Range("h7")
- '以下代码请自行补充完整,这里不再一一罗列
- arr(k, 26) = ""
- arr(k, 27) = ""
- arr(k, 28) = ""
- arr(k, 29) = ""
- arr(k, 30) = ""
- arr(k, 31) = ""
- arr(k, 32) = ""
- arr(k, 33) = ""
- arr(k, 34) = ""
- arr(k, 35) = ""
- arr(k, 36) = ""
- arr(k, 37) = ""
- arr(k, 38) = ""
- arr(k, 39) = ""
- arr(k, 40) = ""
- arr(k, 41) = ""
- arr(k, 42) = ""
- arr(k, 43) = ""
- arr(k, 44) = ""
- arr(k, 45) = ""
- arr(k, 46) = ""
- arr(k, 47) = ""
- arr(k, 48) = ""
- arr(k, 49) = ""
- arr(k, 50) = ""
- arr(k, 51) = ""
- arr(k, 52) = ""
- arr(k, 53) = ""
- arr(k, 54) = ""
- arr(k, 55) = ""
- arr(k, 56) = ""
- arr(k, 57) = ""
- arr(k, 58) = ""
- arr(k, 59) = ""
- arr(k, 60) = ""
- arr(k, 61) = ""
- arr(k, 62) = ""
- arr(k, 63) = ""
- arr(k, 64) = ""
- arr(k, 65) = ""
- arr(k, 66) = ""
- arr(k, 67) = ""
- arr(k, 68) = ""
- arr(k, 69) = ""
- arr(k, 70) = ""
- arr(k, 71) = ""
- arr(k, 72) = ""
- arr(k, 73) = ""
- arr(k, 74) = ""
- arr(k, 75) = ""
- arr(k, 76) = ""
- End With
- Next k
- Wb.Close False '关才Wb工作簿,且不保存更改
- End With '
- Set Wb = Nothing '释放内存
- Range("a3").Resize(UBound(arr, 1), UBound(arr, 2)) = arr
- Application.ScreenUpdating = True '打开屏幕刷新
- End Sub
复制代码 |
|