Q
qyang
In Excel XP or Excel 2003, we can add picture to worksheet from url, besides
from file. There are two functions that can do the job:
1. ActiveSheet.Pictures.Insert Filename:=strUrl
2. ActiveSheet.Shapes.AddPicture Left:=10, Top:=10, _
Width:=100, Height:=100, _
Filename:=strUrl, LinkToFile:=msoFalse, SaveWithDocument:=msoTrue
However, in Excel 2007, both of the above functions don't work. I'm not sure
if the same function is taken away from Excel 2007, or if some settings are
not set properly.
thanks for any help
from file. There are two functions that can do the job:
1. ActiveSheet.Pictures.Insert Filename:=strUrl
2. ActiveSheet.Shapes.AddPicture Left:=10, Top:=10, _
Width:=100, Height:=100, _
Filename:=strUrl, LinkToFile:=msoFalse, SaveWithDocument:=msoTrue
However, in Excel 2007, both of the above functions don't work. I'm not sure
if the same function is taken away from Excel 2007, or if some settings are
not set properly.
thanks for any help