|
本帖最后由 bluexuemei 于 2015-1-7 07:55 编辑
- Sub 添加图片批注()
- Dim doc, XmlHttp, ojs, s, img
- Set XmlHttp = CreateObject("msxml2.xmlhttp")
- Set ojs = CreateObject("scriptcontrol"): ojs.Language = "rubyscript"
- For Each cell In Selection
- XmlHttp.Open "GET", cell.Value, False
- XmlHttp.Send
- s = XmlHttp.responsetext
- If InStr(s, "<h3>商品画像</h3>") > 0 Then
- s = Split(Split(s, "<h3>商品画像</h3>")(1), "商品説明")(0)
- w = ojs.eval("'" & s & "'.scan(/<img src.+width=""(\d+)""/)[0][0].to_i")
- h = ojs.eval("'" & s & "'.scan(/<img src.+height=""(\d+)""/)[0][0].to_i")
- img = ojs.eval("'" & s & "'.scan(/<img src\=""(.+?.jpg)/)[0][0]")
- With cell(1, -1)
- .ClearComments
- .AddComment
- .Comment.Shape.Fill.UserPicture img
- .Comment.Shape.Height = h
- .Comment.Shape.Width = w
- End With
- End If
- Next
- Set ojs = Nothing
- Set XmlHttp = Nothing
- Stop
- End Sub
复制代码 |
|