|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
我替黄版给你写了吧
- Sub Test()
- Dim js As String
- With CreateObject("Microsoft.XMLHTTP")
- .Open "get", "http://chemours-site.force.com/resource/1480126687000/CRGRes/scripts/tlargi.min.js", False
- .send
- Do While Not .ReadyState = 4
- DoEvents
- Loop
- js = .responseText & ";var r,k,n=c=1,d={};for(r in db_elastomers_ratings){n++;for(k in db_elastomers_ratings[r]){if(!d[k]){d[k]=c++;rng(1,d[k])=k;}rng(n,d[k])= db_elastomers_ratings[r][k];}}" & ";" & js
- End With
- With CreateObject("ScriptControl")
- .Language = "JScript"
- .AddObject "rng", [a1]
- .eval (js)
- End With
- [a:v].Columns.AutoFit
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|