View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] es330td@gmail.com is offline
external usenet poster
 
Posts: 7
Default 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?