October 1st, 2003, 09:24 PM
|
|
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.
|