Thanks Dave,

That would probably be an option I could use. I keep hoping for a more
direct programmatic way to do this. This feels like something that MS must
have thought of somewhere as I can't be the only person who wants to display
an image in Excel that gets updated when the source file is updated.

I will keep this as an option but will still seek another way.

Thanks for your help!

--
Glenn

"Dave Peterson" wrote in message
...
I would record a macro when I deleted the existing picture and inserted
(and
positioned) the replacement picture.

Then rename this macro to Auto_Open. That means that the macro will run
each
time excel opens (if the user is allowing macros to run).

If I were really industrious, I could keep track (on a hidden worksheet?)
the
last modified date for the picture. Then check to see what the date is on
that
file and then import the file.

Actually, I don't think I'd worry about that. I'd just import the picture
file
each time the workbook opened.

Glenn Mulno wrote:

Hi,

First - I apologize - I posted this earlier on public.excel - so this is
a
cross post. I apologize if you subscribe to that list and this is a
repeat.
Just trying to get a wider audience.

I am trying to have Excel show/display an image from a file and be able
to
update/refresh that image if it changed but am not having any luck. The
image file will get updated weekly - so I am not looking to embed an
image
one time. I want it to link to the source file and when I update the
image
file, it will reflect the new image in Excel the next time Excel opens.

Inserting an image file embeds the image but there is no link to the
source
file for updates.

I tried using the image control - but that did not appear to work right.
It
did display the image, and I can resize the image to proper form - but
the
image does not update the next time I open Excel after replacing the
image.
There is a property of the image control called "AutoLoad" - but after I
set
it to True - when I close and then reopen Excel - the image does not
refresh
and that property is somehow reset to False.

At the moment - I am getting images sent to me in .png format - if the
solution could handle that it would be great. The steps I tried above I
tried with a converted jpg image and that did not work. The png image
file
seems even less friendly.

I am using MS Office 2007 and the file is a .xlsm (macro enabled) file.

Thanks for any help you can provide.

--
Glenn

--

Dave Peterson