Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Create folders through excel

Posted on 2007-08-07
7
Medium Priority
?
911 Views
Last Modified: 2008-01-09
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
0
Comment
Question by:bsharath
  • 4
  • 3
7 Comments
 
LVL 29

Expert Comment

by:leonstryker
ID: 19646782
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
0
 
LVL 11

Author Comment

by:bsharath
ID: 19646809
Leon,

Thanks.But i have no idea about vba script.can you help>>>
0
 
LVL 29

Accepted Solution

by:
leonstryker earned 2000 total points
ID: 19646856
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 11

Author Comment

by:bsharath
ID: 19708958
Any script which can do all the 3 steps.
1. Create a folder
2. Share the folder
3. Give permissions for share and Ntfs...
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 19716609
Have you looked at any of the tutorials?
0
 
LVL 11

Author Comment

by:bsharath
ID: 19725408
Ye i went through all the links but none have a script to do all these 3 things in 1 script...
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 19733156
So, put them together.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question