Link to home
Start Free TrialLog in
Avatar of bsharath
bsharathFlag for India

asked on

Create folders through excel

Hi,

I want a way to create folders,share them,Give share permissions and security permissions from a excel sheet.

EX:
Folder name    Share name    Share permissions name      Security permission Name


Is there a way to do this. In share permissions and security permissions i shouls have all the names in a scroll type to select all th names and groups which i want.

regards
Sharath
Avatar of leonstryker
leonstryker
Flag of United States of America image

Basically you will need to use VBA code, although your parameters (file and folder names) may be on the spread sheet itself. The easiest way would be to establish a reference to the FileSystem object.  Take a look here. The code is for VBS but you should be able to adjust it to VBA fairly easialy:

http://www.elated.com/articles/the-filesystem-object/

Leon
Avatar of bsharath

ASKER

Leon,

Thanks.But i have no idea about vba script.can you help>>>
ASKER CERTIFIED SOLUTION
Avatar of leonstryker
leonstryker
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Any script which can do all the 3 steps.
1. Create a folder
2. Share the folder
3. Give permissions for share and Ntfs...
Have you looked at any of the tutorials?
Ye i went through all the links but none have a script to do all these 3 things in 1 script...
So, put them together.