i have written codes in excel to show data from database(MsSQL) all o
them can be done except pictures .does anyone know that excel can sho
the picture from the database ?:eek

--
worldapar
-----------------------------------------------------------------------
worldapart's Profile: http://www.excelforum.com/member.php...fo&userid=3139
View this thread: http://www.excelforum.com/showthread.php?threadid=51096

You dont say how you are displaying the data. So the answer can only be
very general.

Where and how are you displaying the data?
How is the picture "stored" in the database?
What format is the stored data?

But principlaay you will need to place a container of some sort (eg a
shape or a VBA ImageControl) depending on what you are going to do with
it) and set the property of the control to the image file or to an
imageControl.

If the number of images is dynamic then you will benefit by creating
the containers (position and size) on the fly.

More clarity in your question may result in a more prescriptive
answer.

regards,


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=510960