Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 .AddPictu Can it use a URL as a source?
I am trying to run this command
set mypic = xl.sheets("PROJECT").Shapes.AddPicture(myFil,True, True, 0,0,100,100) where myFil = "http://devserver/pictures/testpic.jpg" but it tells me that the file cannot be found. If I type the value into IE the picture comes up, and if I replace the http with a local path, i.e. c:\inetpub\wwwroot\.... it works. In Excel 2003 a URL was an acceptable value. Can this work in Excel 2007? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 .AddPictu Can it use a URL as a source?
Hopefully the URL at the bottom of this post will work. I replied to another
post before seeing yours. The sudden unexplained change in AddPicture behavior from Excel 2003 to 2007 has been a huge source of frustration for me. I half expected Office 2007 SP1 to offer a solution, but it doesn't even resolve the problem of not being able to record a macro to show the method that Excel uses natively for inserting image links. http://www.microsoft.com/communities...=en-us&m=1&p=1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 AddPicture help needed | Excel Programming | |||
Excel 2007 change pivot data source | Excel Discussion (Misc queries) | |||
Excel 2007 Prohibits Shapes.AddPicture from URL? | Excel Programming | |||
Excel 2007 change data source | Excel Discussion (Misc queries) | |||
Shapes.AddPicture run-time error | Excel Programming |