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

YARON

New Member
Joined
May 20, 2019
Messages
1
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
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
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.

1679651529838.png


Download link: GoogleDriveAPI.xlam
Note: Excel 2019 or later is required to run this macro.
 
Upvote 1
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!
 
Upvote 0
Hello

I am trying to implement the same google drive api.

It will be possible to activate that GoogleDriveAPI.xlam link

Thanks in advance
J.M.Sotelo
 
Upvote 0

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top