Omen666blue
New Member
- Joined
- Aug 13, 2012
- Messages
- 39
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
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