=IMAGE(B2)
IMAGE函数生成二维码 ▼
=IMAGE('https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=' & A2)
Sub getIMage()
Dim rngData As Range, rng As Range, rngWhere As Range, shp As Shape, image As Picture
On Error Resume Next
Set rngData = Application.InputBox('请选择图片链接所在的单元格区域', Type:=8)
Set rngData = Intersect(rngData.Parent.UsedRange, rngData)
If rngData Is Nothing Then MsgBox '选择的单元格范围不存在数据!': Exit Sub
Set rngWhere = rngData.Offset(0, 1) '图片存放单元格
Application.ScreenUpdating = False
rngWhere = ''
For Each shp In ActiveSheet.Shapes '如果旧图片存放在目标图片存放范围则删除
If Not Intersect(rngWhere, shp.TopLeftCell) Is Nothing Then shp.Delete
Next
For Each rng In rngData '遍历网址单元格
Set image = ActiveSheet.Pictures.Insert(rng.Value, False) '插入图片
With rng.Offset(0, 1) '调整图片的位置和大小
image.Top = .Top + 3
image.Left = .Left + 3
image.Width = .Width
image.Height = .Height - 6
End With
Next
Application.ScreenUpdating = True
If Err Then
MsgBox Err.Description
Else
MsgBox '处理完成'
End If
End Sub
复制代码运行后,系统会弹出一个选择框,鼠标框选图片链接所属的单元格区域后确定,稍等片刻,即可在隔壁列显示对应的图片。
除此之外,如果你的需求并不是将网址生成的图片显示在单元格中,而是下载到电脑的文件夹内……那当然也不是不行。
联系客服