Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sorry for the double post. My ignorance.
This is what I needed. Great. Thanks Joel. "Joel" wrote in message ... what you are doing is wrong Private Sub Worksheet_Activate() WebBrowser1.Navigate "www.worldcommunitygrid.org/images/pb/faah_0.jpg" End Sub 1) The worksheet Activate will load the picture everytime you change the worksheet. You only need to load the picture once. 2) You don't need to use a web browser function. Just inserting the picture will work. Here is the code I think you should use Sub GetPicture() PictureURL = "http://www.worldcommunitygrid.org/images/pb/faah_0.jpg" Set MyPict = ActiveSheet.Pictures.Insert(PictureURL) End Sub I tested this code and it work just like it should. "Gandalf the White" wrote: Joel, again thanks for the reply, but again I'm not into VB. Your code is like Greek to me. Multiple lines of Greek is still Greek. :) The code from my post seems to create a small IE window inside the cell. It's just not bringing in the image. Can someone show me how to make "my" code work? All assistance gratefully appreciated. Gandalf |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Connect a number to a picture bank and import that picture to exce | Excel Discussion (Misc queries) | |||
import a picture into a pre defined range of cells - excel 2003 | Excel Discussion (Misc queries) | |||
How can I Import picture contents into Excell cell array numbers? | Excel Worksheet Functions | |||
How can I Import picture contents into Excell cell array numbers? | Excel Worksheet Functions | |||
how do i import a picture or drawing into an excel spreadsheet? | Excel Discussion (Misc queries) |