|
- Public sjk As Variant
- Sub test()
- Dim r%, i%
- Dim brr
- Dim wb As Workbook
- Dim ws As Worksheet
- Dim mypath$, myname$
- ChDrive Split(ThisWorkbook.Path, "")(0)
- ChDir ThisWorkbook.Path
- myfile = Application.GetOpenFilename(fileFilter:="Excel文件(*.xls*),*.xls*", Title:="选择Excel文件")
- If myfile = False Then
- MsgBox "没有选择文件", vbCritical, "错误"
- Exit Sub
- End If
- Set wb = GetObject(myfile)
- With wb
- With .Worksheets("sheet1")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- c = .Cells(1, .Columns.Count).End(xlToLeft).Column
- sjk = .Range("a1").Resize(r, c)
- End With
- .Close False
- End With
- frm_dr.Show
- End Sub
- Sub daoru(ByVal d_zd As Object)
- Dim r%, i%
- Dim brr
- With Worksheets("理科")
- .UsedRange.Offset(1, 0).ClearContents
- c = .Cells(1, .Columns.Count).End(xlToLeft).Column
- arr = .Range("a1").Resize(1 + UBound(sjk), c)
- For j = 1 To UBound(arr, 2)
- If d_zd.exists(arr(1, j)) Then
- n = d_zd(arr(1, j))
- For i = 1 To UBound(sjk)
- arr(i + 1, j) = sjk(i, n)
- Next
- End If
- Next
- .Range("a1").Resize(UBound(arr), UBound(arr, 2)) = arr
- End With
- End Sub
复制代码 |
|