Transferring an image from webcam to hard drive

Hi,

I've helped create a macro that helps to automate our QC department. What the macro does is it looks up the item number based on the barcode that the scanner reads and brings up the item number, the item description, total of units in a case, how much a single box of the item will weigh and how many units in the inner box may be sold at one time. The trouble is that not all items have an image available so that the person who is doing the checking knows what the item looks like.

There is a Logitech webcam setup to take pictures of the items. The following code allows us to import the image of the item into excel in a given cell:

Application.SendKeys ("{ENTER}")
Application.CommandBars.FindControl(ID:=1764).Execute

Can this code be modified so that it not only imports the image to excel but also copy the image from the webcam and move it out to the hard drive so that it can be resaved using the item number?

When the image is resaved with product number it is associated with the database. The associated image then comes up when the barcode is read from the scanner.

If it isn't possible to move an image from a webcam to the hard drive is there an alternative that can still achieve the same result?

I've used Microsoft Excel 2007 VBA to write the program to do the job but I had to be careful to make sure it was backwords compatible with Excel 2003 so that the QC department can use it.

Thanks,
Tim Martin