VBA : A picture from http://.../Image.gif
 

With Excel 2000, in a workbook, I want to show a picture (in a shape for
example) that I can pick up directly from an HTTP URL :

http://MyServer/MyImage.jpg

I don't want to store it, just declare a link with the URL.

I've tried with Shape/Hyperlink/PublishObjects but I can't.

How to do ?

(The final goal is a dynamic URL that I can change by VBA.)

Jacques.

A picture from http://.../Image.gif
 

Hi Jacques,

You can do it in VBA like this:

Sheet1.Shapes.AddPicture "http://server/folder/image.gif", msoTrue,
msoFalse, _
100, 100, 100, 50

Hopefully, you'll know the height and width, because those are required
arguments to the AddPicture method.

--
Regards,

Jake Marx
www.longhead.com


VUILLERMET Jacques wrote:
With Excel 2000, in a workbook, I want to show a picture (in a shape
for example) that I can pick up directly from an HTTP URL :

http://MyServer/MyImage.jpg

I don't want to store it, just declare a link with the URL.

I've tried with Shape/Hyperlink/PublishObjects but I can't.

How to do ?

(The final goal is a dynamic URL that I can change by VBA.)

Jacques.

A picture from http://.../Image.gif
 

You're right !

Thanks a lot !!!

Jacques.


"Jake Marx" a écrit dans le message de
...
Hi Jacques,

You can do it in VBA like this:

Sheet1.Shapes.AddPicture "http://server/folder/image.gif", msoTrue,
msoFalse, _
100, 100, 100, 50

Hopefully, you'll know the height and width, because those are required
arguments to the AddPicture method.

--
Regards,

Jake Marx
www.longhead.com


VUILLERMET Jacques wrote:
With Excel 2000, in a workbook, I want to show a picture (in a shape
for example) that I can pick up directly from an HTTP URL :

http://MyServer/MyImage.jpg

I don't want to store it, just declare a link with the URL.

I've tried with Shape/Hyperlink/PublishObjects but I can't.

How to do ?

(The final goal is a dynamic URL that I can change by VBA.)

Jacques.