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

Hi qyang

I see the same thing after testing
Will try to find a answer for you


--

Regards Ron de Bruin
http://www.rondebruin.nl



"qyang" wrote in message
...
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

Hi qyang

I will send a bug report to my connections with Microsoft

--

Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message
...
Hi qyang

I see the same thing after testing
Will try to find a answer for you


--

Regards Ron de Bruin
http://www.rondebruin.nl



"qyang" wrote in message
...
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

Thanks. I think it is a bug in Excel 2007.


"Ron de Bruin" wrote:

Hi qyang

I will send a bug report to my connections with Microsoft

--

Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message
...
Hi qyang

I see the same thing after testing
Will try to find a answer for you


--

Regards Ron de Bruin
http://www.rondebruin.nl



"qyang" wrote in message
...
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

Not an answer, but what code do you get when recording a macro of the
InsertPictureFrom File actions in XL2007 ?

NickHK

"qyang" wrote in message
...
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

Sorry for a little delay, because the Discussion Group pages totally
disfunction at office today. I have to reply from home.

I can record the same macro in Excel 2003, but no macro can be recorded in
Excel 2007. That's another bug of Excel 2007. I did really have recorded
macros for other actions.


"NickHK" wrote:

Not an answer, but what code do you get when recording a macro of the
InsertPictureFrom File actions in XL2007 ?

NickHK

"qyang" wrote in message
...
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