Hi all, is it possible to, on the click of a command button take a picture using a webcam (or other such device) name it, save it to a folder and create a hyperlink to it in a cell?
My intention is that when a new employee is recruited and a userform is filled in (already created that) when the command button to commit the data is clicked i would like to be able to automatically take a picture of the employee save the picture as lets say TextBox1.Value store it in a folder called "Employee ID" (if it's not present create it) and then create a hyperlink to it in Sheets("Staff Details").Range("A1") (ficticious location as the location will be determined by the userform finding last entry and and using Rng.Offset to place the hyperlink in the cell).
This way ID badges can be made easily plus when employee records are called up a face will be put to the name (not only important for payment to the employee as they will mostly be agency workers but for security and legal reasons).
Any thoughts and ideas on how to accomplish this?
Regards,
Simon