Take photo from camera app on Windows 10 tablet directly into Excel?

[dionysus_83]

I'm completely clueless here! I do have some code to run the app from Excel and then user can use camera regularly, but how to save taken picture directly into Sheet?

[/FONT][/COLOR]Sub RunCam()

Dim SHRTCT As String
Dim RNCMD As String


SHRTCT = "C:\Users\Public\Desktop\yyyy.lnk"


RNCMD = "RunDLL32.EXE shell32.dll,ShellExec_RunDLL "
Shell (RNCMD & SHRTCT)



End Sub[COLOR=#242729][FONT=Arial]

This will run the app, but how to grab a picture taken into Excel?

 

[dionysus_83]

Re: How to take photo from camer app on Windows 10 tablet directly into Excel?

Maybe with a screenshot? How could I screenshot with VBA once camera is open a large portion of the screen?