VBA to Create Permission for files and folders in Google Drive Office

VBA to Create Permission for files and folders in Google Drive Office Now coming to creating uh uh permission so you can you know like uh the use case i think here will be you can uh.

If you have like lots of users you have to give access to uh separate access based on the folder and files and so on you can upload and directly give access.

Dynamically again all these functions can be clubbed together you can you know i call many different methods uh you know here you can continue calling different.

Different methods even the sheets uh methods later on i'll show how to combine them together okay so now let's uh give permission to these files so for.

Example let's say uh let me choose the easier file name so um does not matter though but so same file.

Sample file under pdf at the moment if i go here it says it's not shared so let's try and give this i'll give this um here.

VBA to Create Permission for files and folders in Google Drive

Start a service create permission object id is we're looking at the object id for sample1.pdu and then the type is user and then you.

Can give so you can use this options group domain anyone so if you want to give a user access you're going to specify user here.

Writer what sort of role you want to give it to and then the email id and then you can specify this as any for now and i'm going to run this f5.

And here you'll get the permission id so if you automatically create this then you can have like uh your small database where you log the email id associated with um.

You know the the permission id so that you can relate and map them later because uh you cannot pull the list of the users who have access to that particular file.

Okay only permission id so here you can see that uh it has now the owner is me and then this is the user edit at the moment now one more example would be to add.

    Anyone

    Um here is the example let me do this so anyone will have a read access okay and let me remove this part now and f5 so this one is basically saying that.

    Give access to anyone the reason type is anyone and here you don't have to specify the email id is any yeah and if i change this you'll.

    DISCLAIMER: In this description contains affiliate links, which means that if you click on one of the product links, I'll receive a small commission. This helps support the channel and allows us to continue to make videos like this. All Content Responsibility lies with the Channel Producer. For Download, see The Author's channel. The content of this Post was transcribed from the Channel: https://www.youtube.com/watch?v=ZHCnPfHueGg
Previous Post Next Post