If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|