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

Y

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"
Sort by date Sort by votes
hillbilly63 said:
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.
Click to expand...
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
nguyendang said:
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.
Click to expand...
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
You must log in or register to reply here.

Similar threads

M
  • Question
Convert all excel files from a folder to google sheets and output to another folder
Replies
2
Views
1K
veyselemre
veyselemre
M
  • Question
Help with Solution better than nested IF
Replies
1
Views
439
Zaifee
Z
J
  • Question
Saving a sheet as a PDF and preserving links to pages in the sheet
Replies
6
Views
1K
Sabooru
S
T
  • Question
Pop Up Message if specific cells are greater than other specific cells
Replies
5
Views
578
tabs1063
T
spacecaptainsuperguy
  • Question
Advice for linked files on network drive
Replies
0
Views
418
spacecaptainsuperguy
spacecaptainsuperguy

Forum statistics

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

Share this page

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