View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Steven@pctamers.eu is offline
external usenet poster
 
Posts: 30
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