View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default VBA to launch camera app, take photo & insert in a cell

Hi

Windows 10; Excel 2013; linx tablet

I have a requirement where I need to have XL launch the camera app,
wait for me to take a photo, then insert the photo into a particular
cell. Has anyone done that or have any idea how to do it?

I have found the code below

Shell ("C:\Program Files (x86)\Internet Explorer\iexplore.exe")

which works a treat to launch ie . . . the issues I need answers to
a

1) I don't know the path where the camera app resides on Win10

2) Once the camera app is launched and the photo taken how to get it
placed in the correct cell in the spreadsheet

3) Anything anyone else can think of that I may have overlooked.

Thanks in advance.

Steve


FieldReportonyholden1


Try using *Insert Picture from File* assuming your camera app is saving
the image...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion