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

  • Thread starter Thread starter VUILLERMET Jacques
  • Start date Start date
V

VUILLERMET Jacques

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.
 
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.
 
Back
Top