activate built in camera

Question

I have Excel 2010 and am writing an application that will need to integrate links to pictures on a tablet. The desire is to tap the picture button and that will trigger the camera and allow taking, naming and saving the picture. The name should then be passed back to the sheet for use as the target for the link placed in the cell.

Currently the function is that a browse box is opened and the selected picture is used as the target. I need to replace the browse box with the process of actually taking the picture. Does anyone out there have an add-in or macro that will accomplish this?

Answer 1

My thinking is that there could be an add-in written using VS2010 which would trigger the installed camera software. This would operate similar to the fact that the default picture viewer pops up when you click on a picture link. I would have no problem writing this if I could find the proper direction to start the process.

Answer 2

It works fine in Excel 2010 here, but you are correct that it inserts the image from the web cam into the worksheet. What you are asking for is not available as far as I am aware.

Answer 3

I found and tried that but get an error since this is Excel 2010. My understanding of the function is that it is for Excel 2007 and prior and will insert the picture into the spreadsheet. I need to save the picture to the hard drive. Any other suggestions or an elaboration on that function egarding 2010?

Answer 4

Do you mean like

Sub InsertFromScanner()

Application.CommandBars.FindControl(ID:=1764).Execute

End Sub

?