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?
|