Need your help with the following:
I have a code that pulls images into excel (in my case - excel 2010)
From what I gather, in Excel 2010 - the method I used only creates a link to the image.
Can you please help me with the proper code that will embed the images in the file (and also allow saving them with the file)?
This is the code I have been using:
thispicture = FilePath & "\" & ActiveCell.Value & ".jpg" Set pic = ActiveSheet.Pictures.Insert(thispicture) With pic .ShapeRange.LockAspectRatio = msoTrue .Width = 230 .Top = Range("A" & i + 2).Top + 10 .Left = Range("A" & i + 2).Left + 10 End With Set pic = Nothing
I am looking for something that will work in Excel 2007-2013 the same way.
BTW, I wanted to declare "thispicture" but didn't know the what to declare it as. Any suggestions?