Put a specific picture in Excel...

[Melanie]

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

[Melanie]

Anybody?

[InvisibleDuncan]

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

[Melanie]

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?

[InvisibleDuncan]

Is this what you mean...?

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

[Melanie]

Probably, I'll test it

Thanks!

[Melanie]

Probably, I'll test it

Thanks!