VBA Code to extract image form word doc and input into VBA form.

[Omen666blue]

Hi guys, I have a staff details macro that searched for staff details when a name is input.

what I would like is the staff members picture to be displayed (via the VBA form) when the name is searched.

each employee has a word document containing their details and a single picture of themselves each file is named exactly the same, lets call it EMP_Data.doc for argument sake. each file is saved in the owing managers folder

so for instance when a employee is searched I would lie Excel to search Depot/Manager/Name/staff details/EMP_Data.Doc.

and pull the photo of the employee. The photo does not need to be saved anywhere else JUST displayed on search.


If this possible and does anyone have some useful sample code?

Thanks