Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to launch camera app, take photo & insert in a cell
Hi
Thanks for the response. I'm competent with inserting a file of any type into XL. What I actually asked was that i want to launch the camera app from within XL & have the resulting photo placed in a cell. Any ideas anyone? Steve |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to launch camera app, take photo & insert in a cell
Hi
Thanks for the response. I'm competent with inserting a file of any type into XL. What I actually asked was that i want to launch the camera app from within XL & have the resulting photo placed in a cell. Any ideas anyone? Steve You need to find out if the camera app supports automation! If so then you can automate it within Excel, by accessing its API. Otherwise no! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to launch camera app, take photo & insert in a cell
Thanks again Garry. I'm now on holiday but will try this on my return & post results
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to launch camera app, take photo & insert in a cell
Hi Garry
returned from my holiday now - feeling refreshed and rarin' to go! I've looked into launching the camera app but cannot find the .exe file. After much time I've discovered that apps are stored in C:\Program Files\WindowsApps but within there there is nothing that appears to be the .exe to run. (I am displaying hidden files and file extensions). Any ideas? I'm happy to post somewhere more appropriate, as I feel I've strayed away from XL programming now ;o) Thanks again. Steve |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to launch camera app, take photo & insert in a cell
Hi Garry
returned from my holiday now - feeling refreshed and rarin' to go! I've looked into launching the camera app but cannot find the .exe file. After much time I've discovered that apps are stored in C:\Program Files\WindowsApps but within there there is nothing that appears to be the .exe to run. (I am displaying hidden files and file extensions). Any ideas? I'm happy to post somewhere more appropriate, as I feel I've strayed away from XL programming now ;o) Thanks again. Steve That path is for 64bit apps only. If your camera app is 32bit then look under C:\Program Files (x86)\ Also, see if you can find a forum for camera app users! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a photo into a specific cell? | Excel Discussion (Misc queries) | |||
Insert Photo - help | Excel Discussion (Misc queries) | |||
how do I insert a photo in a protected .xls spreadsheet | Excel Discussion (Misc queries) | |||
Looping to insert photo | Excel Programming | |||
In Excel, can I insert a photo into a comment cell? | Excel Discussion (Misc queries) |