AW: QR Code aus Sheet in Userform laden
30.10.2022 15:32:46
Nepumuk
Hallo Rocco,
teste mal:
Private Sub QRCode(QRCode_Wert As String)
'Variablen deklarieren
Dim sURL As String
Dim strFile As String
Dim objPicture As Picture, objChartObject As ChartObject
'URL definieren
sURL = "https://chart.googleapis.com/chart?cht=qr&&chs=100x100&&chl=" & QRCode_Wert
strFile = Environ$("temp") & "\" & "" & Mid(sURL, InStrRev(sURL, "/") + 1)
'Alten QR-Code löschen, falls vorhanden
On Error Resume Next
ActiveSheet.Pictures("QRCode_" & ActiveCell.Address).Delete
On Error GoTo 0
'QR-Code einfügen
Set objPicture = ActiveSheet.Pictures.Insert(sURL)
With objPicture
.Name = "QRCode_" & ActiveCell.Address
.Left = ActiveCell.Left + 5
.Top = ActiveCell.Top + 5
.Width = .Width * 1.5
.Height = .Height * 1.5
.CopyPicture
End With
strFile = Environ$("temp") & "\Bild.jpg"
Set objChartObject = ActiveSheet.ChartObjects.Add(Left:=0, Top:=0, Width:=objPicture.Width, Height:=objPicture.Height)
With objChartObject
.Activate
With .Chart
.Paste
.Export Filename:=strFile, FilterName:="JPG"
End With
.Delete
End With
Set Image1.Picture = LoadPicture(Filename:=strFile)
Kill strFile
End Sub
Gruß
Nepumuk