Put a specific picture in Excel...

Hi,

I have a text field in my database where I put the name of a picture.jpg...Depending of which record I have selected, I want Excel to search for the picture on the server/pictures where I put all my pictures, and insert the picture in my .xls

Is it possible? and how can I make it?

Thanks

Anybody?

I'm not entirely certain I understand the question.What is your database in, and where does Excel come into all this?

Ok, I have an access2000 database, and I have a project in VB6...I have a button in VB that calls a .xls and I transfer my primary key in the .xls...and in VBA I put a SQL statement

"SELECT * FROM residentiel WHERE NoDossier = '" & Feuil1.Range("C22").Value & "'"

Feuil2.Range("C4").Value = objRS.Fields("nocivic").Value...etc...

but I have a field that I called picture and in it there is the path of the picture and the name of the picture.jpg and now with the path I want to put the picture in a specific cell...can I do this?

Is this what you mean...?

VB Code:

Range("A1").Select
ActiveSheet.Pictures.Insert ("C:\My Documents\Bitmaps\P7270002.JPG")

Probably, I'll test it

Thanks!

Probably, I'll test it

Thanks!