|
发表于 2016-1-6 11:18
|
显示全部楼层
本楼为最佳答案
- Sub 打开指定文件() '用文件选择界面打开文件
- Dim Fil
- ChDir ThisWorkbook.Path
- Fil = Application.GetOpenFilename(filefilter:="EXCEL 工作表(*.xlsx;*.xlsm;*.xls),*.xlsx;*.xlsm;*.xls")
- If Fil = False Then MsgBox "请选择文件!": Exit Sub
- Set wb = Workbooks.Open(Fil) '打开文件
- arr = wb.Sheets(1).[a1].CurrentRegion
- wb.Close False
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- For i = 2 To UBound(arr)
- x = arr(i, 1)
- d(x) = arr(i, 2): d1(x) = arr(i, 3)
- Next
- arr = [a10].CurrentRegion
- For i = 2 To UBound(arr)
- x = arr(i, 4)
- arr(i, 6) = d(x)
- arr(i, 7) = d1(x)
- Next
- [a10].CurrentRegion = arr
- End Sub
复制代码 |
|