Return a google drive share link from the google drive folder in VBA

[YARON]

I'm looking for a way to create a macro which will go to my local google drive folder and the folder name (let's say in cell A1), make it shareable to anyone (manually it's mouse right click >> Google Drive >> Share >> Get shareable link) and write in cell A2 that shareable link

 

[hillbilly63]

Did you manage to achieve this? I'm looking to do exactly the same.

 

[nguyendang]

Did you manage to achieve this? I'm looking to do exactly the same.

You can use Google Drive API.

 

[hillbilly63]

You can use Google Drive API.

The difficulty is identifying the file on web drive by the desktop files local path. I know it is possible (Get Drive files by path or id — drive_get) but wondered if there was a way to interact with the desktop Google app to achieve the end goal.

 

[nguyendang]

The difficulty is identifying the file on web drive by the desktop files local path. I know it is possible (Get Drive files by path or id — drive_get) but wondered if there was a way to interact with the desktop Google app to achieve the end goal.

I suggest designing a simple userform which contains the following controls:
1. A treeview control for listing files and folders on Google Drive.
2. A "WebViewLink" button which retrieves and displays the web view link of a file or folder selected in treeview control.

Download link: GoogleDriveAPI.xlam
Note: Excel 2019 or later is required to run this macro.

 

[hillbilly63]

I suggest designing a simple userform which contains the following controls:
1. A treeview control for listing files and folders on Google Drive.
2. A "WebViewLink" button which retrieves and displays the web view link of a file or folder selected in treeview control.

View attachment 88304

Download link: GoogleDriveAPI.xlam
Note: Excel 2019 or later is required to run this macro.

That is awesome, thanks!