|
就是我写的这段代码它把图片提取到合并单元格的时候就会报错,我自己尝试改过很多次还是不行,麻烦您看一下是需要怎么改
- Sub LoadPic(ByVal URL As String, ByVal rng As Range)
- With CreateObject("new:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")
- .settext "<table><img src=""" & URL & """ width=""70"" height=""70"">"
- .putinclipboard
- ActiveSheet.Paste Destination:=rng
- End With
- Application.CutCopyMode = False
- End Sub
- Sub photo()
- Dim i As Integer
- Application.ScreenUpdating = False
- Dim shp As Shape
- For Each shp In ActiveSheet.Shapes
- If shp.Type <> 8 And shp.Type <> 12 Then shp.Delete
- Next
- For i = 2 To 10
- LoadPic Cells(i, 2).Value, Cells(i, 5)
- Next
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|