Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-19-2019, 08:33 PM   #1
MBMSOFT
Newly Registered User
 
Join Date: Jan 2010
Location: ohrid, macedonia
Posts: 85
Thanks: 5
Thanked 1 Time in 1 Post
MBMSOFT is on a distinguished road
Copy file (e.g. picture) from android device (e.g. cell phone, tablet...) to PC

I'm trying to Copy file (e.g. picture) from android device (e.g. cell phone, tablet...) to PC, but i did stack
I did get the path and read and execute shell command to the device folder like
Code:
device = "::{20D04FE0-3AEA-1069-A2D8-08002B30309D}\\\?\usb#vid_12d1&pid_1082&mi_00#6&15652f25&0&0000#{6ac27878-a6fa-4155-ba85-f98f491d4f33}"
Call CreateObject("Shell.Application").ShellExecute(device & "\Internal storage\DCIM\CAMERA\12.jpg")
but I can't copy the file from the folder to my PC
filesystemobject doesn't copy from namespace folders
so it should be some shell or some script command

I'll respect any help
thanks

MBMSOFT is offline   Reply With Quote
Old 11-04-2019, 07:46 AM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,358
Thanks: 554
Thanked 946 Times in 895 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Copy file (e.g. picture) from android device (e.g. cell phone, tablet...) to PC

I note you have yet to receive a reply! In order to give your post a second shot, I have made a comment to bump it up the list! Hope you have better luck this time!
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is online now   Reply With Quote
Old 11-04-2019, 07:59 AM   #3
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 1,207
Thanks: 10
Thanked 226 Times in 214 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Copy file (e.g. picture) from android device (e.g. cell phone, tablet...) to PC

Out of my realm. Maybe you have to create the folder object first?
https://docs.microsoft.com/en-us/win...hell-namespace
But that doesn't look like it's for vba. You might be able to use a scripting library reference within Access though.
There are also vba suggestions here but I don't see where they were accepted as the solution
https://stackoverflow.com/questions/...amespace-items

__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is offline   Reply With Quote
Old 11-04-2019, 12:21 PM   #4
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,690
Thanks: 93
Thanked 1,703 Times in 1,576 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Copy file (e.g. picture) from android device (e.g. cell phone, tablet...) to PC

Crazy me, I would have sent the pic as an attachment to an e-mail.

Now if you have a LOT of these, then maybe not. How many are we talking about and how often?

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Get path to file (e.g. picture) in android device (e.g. cell phone, tablet...) MBMSOFT Modules & VBA 7 10-16-2019 12:59 AM
How to open Access Database on Android Device ? quzher General 2 01-21-2015 03:51 PM
Forum for mobile phone / tablet apps ColinEssex Site Suggestions 3 11-28-2014 08:05 AM
Access database from mobile phone/tablet? cw3k General 3 09-05-2013 04:27 PM
<< OLE Object: Picture (Device Independent Bitmap) >> ddaccess General 0 04-23-2009 08:06 AM




All times are GMT -8. The time now is 01:40 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World