Ken thanks for the analysis, you can see what i'm getting at though, it doesn't need to be available to the userform, its just if she fills in the userform that records an employees details i wanted on close to be able to snap the employee, save it as employee name perhaps in a designated folder and then deposit a hyperlink for it at the end of the employee record.

Not being very experienced in VBA i wouldnt have the foggiest idea on manipulating applications outside of Excel, the hyperlink i could probably work out (but on second thoughts i only want the hyperlink to call the picture in to excel temporary for printing or inclusion in a report). I have no idea what API is or means at a guess Advanced Program Interface, but that still doesnt tell me anything.

I will trawl the internet for any other solutions.....i asked the question here first because this is where the experts hang out! LOL i don't class myself in that category but you never know rubbing shoulders and some may rub off!

Regards,
Simon