How to list links in Gdrive shared folder

ABBAN270 · Mar 6th 2021

Hello every one

how can i list file links in my shared folder on Google drive

if it is not possible

how can i download all files found on the folder

thanks in advance

**Carim** · Mar 6th 2021

Hello,

Not familiar at all with Google and its cloud service ...

You can always test following macro to loop through files in folder and get a list :

Code

Sub LoopThroughFiles ()
Dim oFSO As Object
Dim oFolder As Object
Dim oFile As Object
Dim i As Integer

Set oFSO = CreateObject("Scripting.FileSystemObject")
' Adjust the Folder to yous specific situation ''''''
Set oFolder = oFSO.GetFolder("C:\VBA Folder")
For Each oFile In oFolder.Files
    Cells(i + 1, 1) = oFile.Name
    i = i + 1
Next oFile
End Sub

Display More

Hope this will help

ABBAN270 · Mar 9th 2021

thanks

but am talking about files on gdrive

not in my hard drive

**Carim** · Mar 10th 2021

Hello,

In order to get the Google Drive path, take a look at following :

https://stackoverflow.com/ques…-of-google-drive-document

Hope this will help

ABBAN270 · Mar 10th 2021

but this is not a vba language !!!

How to list links in Gdrive shared folder

Participate now!

Share