Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Link Not Embed Images from URL
I was using the Shapes.AddPicture method to link pictures stored on the
Internet to my spreadsheet, but then we upgraded to Excel 2007 and I had to start using Shapes.AddShape along with the Fill.UserPicture method. The AddPicture method allows for embedded pictures, even if the image is stored on the Internet by setting LinkToFile = True and SaveWithDocument = False. Set oPicture = ActiveSheet.Shapes.AddPicture(FileName:= €œhttp://www.website.com/test_image.jpg€, LinkToFile:=msoTrue, SaveWithDocument:=msoFalse, iLeft, iTop, iWidth, iHeight) But UserPicture does not seem to allow for linking. Is there a way to avoid embedding pictures using the UserPicture method? Set oPicture = ActiveSheet.Shapes.AddShape(msoShapeRectangle, iLeft, iTop, iWidth, iHeight) oPicture.Fill.UserPicture oFileName In a perfect world Microsoft would fix the AddPicture using URL problem in Excel 2007. For the time being, however, I just need the images showing in my spreadsheet to be linked (not embedded) to images on the Internet. Thanks for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Link Not Embed Images from URL
This is a link to the Microsoft KB article about the AddPicture method
problem when used in Excel 2007 on images "located in an HTTP location": http://support.microsoft.com/default...b/928983/en-us |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To Embed Link That Mails My Workbook | Excel Discussion (Misc queries) | |||
Can I embed a pdf doc like a link? | Excel Discussion (Misc queries) | |||
Link or embed into Word? | Excel Discussion (Misc queries) | |||
How do I un-embed images in Excel and save them to another folder. | Excel Discussion (Misc queries) | |||
Link and embed pdf into excel | Links and Linking in Excel |