VBA to list files in iPhone DCIM internal storage

[Nadine]

Hello and thank you for any attention my post may receive.

I have a need to list the files in the DCIM subfolders of my iphone 10. I have VBA, from another site, which does the job nicely for files in the folders of my computer however I am struggling with the same for my iPhone.

This is the code I am using:

Dim oFSO As Object
Dim oFolder As Object
Dim oFile As Object
Dim i As Integer
 
Set oFSO = CreateObject("Scripting.FileSystemObject")
 
Set oFolder = oFSO.GetFolder("This PC:\Apple iPhone\Internal Storage\DCIM\111APPLE")
 
For Each oFile In oFolder.Files
 
    Cells(i + 1, 1) = oFile.Name
 
    i = i + 1
 
Next oFile

The error lies in setting the 'oFolder'.

Any help would be greatly appreciated.

 

[6StringJazzer]

Try it without the ":"

 

[6StringJazzer]

Actually I tried that myself and it didn't work, I just got nothing back. A quick search shows this may be more complicated than expected.

 

[Nadine]

Actually I tried that myself and it didn't work, I just got nothing back. A quick search shows this may be more complicated than expected.

Thank you for your time and reply Jeff.

Yes I think you may be correct. Oh well.....sigh....