dynamically update photos in excel

[cmotes]

I'm using Excel to generate invoices. I have an invoice template that
uses a distinct item number to lookup basic info on the item, and show
it on the invoice (using vlookups). Easy. One of the items being
looked up is a photo URL for the item (example:
http://farm4.static.flickr.com/3133/pictureid.jpg) which I need to
display on each invoice.

I generate new invoices by updating the item number. I'd like the
invoice template to automatically update the picture of the item when
I update the item number. Today I have to manually embed the photos
via Insert->Picture and then copying in the photo URL.

Put another way, when item number changes, Excel runs a bunch of
vlookups to grab item data including a new photo URL... I want that
photo to actually update on the invoice template automatically.

Ideas?

 

[Gord Dibben]

John McGimpsey's lookuppics should fo the trick.

http://www.mcgimpsey.com/excel/lookuppics.html


Gord Dibben MS Excel MVP