How to open files in VBA for excel on a "portable device" / "external device" / "mobile device"

[Bernst]

Hello All.

in advance: My native language is NOT english, sorry for eventually missunderstandings.

Since several days I'm searching the internet for a solution to open files directly on my navigation-device (Garmin nüvi 2597LMT).
I found some ideas and snippets, but I didn't find the final solution.
Whith these ideas and snippets I figured out the following:

When I enter "::{20D04FE0-3AEA-1069-A2D8-08002B30309D}\\\?\usb#vid_091e&pid_462e#0000e7bd0f18#{6ac27878-a6fa-4155-ba85-f98f491d4f33}\Internal Storage\GPX\Archive\" into the windows-explorer, it will change the directory (from everywhere) to the named GPX-Archive on my external device (nüvi 2597LMT)

When I enter "::{20D04FE0-3AEA-1069-A2D8-08002B30309D}\\\?\usb#vid_091e&pid_462e#0000e7bd0f18#{6ac27878-a6fa-4155-ba85-f98f491d4f33}\Internal Storage\GPX\Archive\myTracks.gpx" into the windows explorer, it will open the file "myTracks.gpx" in the editor.

What I'm looking for is something similar like:
For Each strFile in Folders.Files
Open strFile
Next strFile

Does anybody can help me?
Thanks in advance,
Berny

 

[Bernst]

Hi All.

What I forgot to say, is:
Whether the file-dialog-box of excel nor the file-dialog-box of vba for excel let me open the file!
Doesn't matter which way I use - the one with the cryptic looking path or by the step by step folder selection.
Even the file-dialog-box of the windows-explorer does it in both ways!

Is there maybe a DLL-file I have to link/connect to the vba, which contains commands similar to the commands of the filesystem?
And if "yes" which ones and how do i have to use it (example file/snippets would be fine - remember, I'm just an autodidact )

Many thanks, in advance,
Berny