I have been using vlookups for ages to create 'dynamic' pages, ie you
select the product/shop it gives you the data in a page for that
place. I have been asked if I can include pictures....

Is this possible. If the Photos are in a common name format ie c/my
pics/shop 1 etc can there be some VBA code that will pull this from
the folder and insert.

Thanks

Matthew

To have a picture show up when you select an item from a DV list or type in a
name see JE MCGimpsey's site.

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

OR Debra Dalgeish's site for a sample workbook from Bernie Dietrick for adding
pictures to selections.

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection


Gord Dibben MS Excel MVP

On Fri, 13 Jul 2007 14:27:54 -0700, Matthew wrote:

I have been using vlookups for ages to create 'dynamic' pages, ie you
select the product/shop it gives you the data in a page for that
place. I have been asked if I can include pictures....

Is this possible. If the Photos are in a common name format ie c/my
pics/shop 1 etc can there be some VBA code that will pull this from
the folder and insert.

Thanks

Matthew

Hi,

You can view this URL: http://www.mcgimpsey.com

Challa Prabhu

"Matthew" wrote:

I have been using vlookups for ages to create 'dynamic' pages, ie you
select the product/shop it gives you the data in a page for that
place. I have been asked if I can include pictures....

Is this possible. If the Photos are in a common name format ie c/my
pics/shop 1 etc can there be some VBA code that will pull this from
the folder and insert.

Thanks

Matthew

On 14 Jul, 06:50, challa prabhu
wrote:
Hi,

You can view this URL:http://www.mcgimpsey.com

Challa Prabhu

"Matthew" wrote:
I have been using vlookups for ages to create 'dynamic' pages, ie you
select the product/shop it gives you the data in a page for that
place. I have been asked if I can include pictures....

Is this possible. If the Photos are in a common name format ie c/my
pics/shop 1 etc can there be some VBA code that will pull this from
the folder and insert.

Thanks

Matthew

Thanks to all another job well done !