sleepy_think
08-11-2008, 08:51 AM
Heya everyone,
Here is the following issue I am having:
( I attached a simple example of the possible data )
I would like to scan through the groups in column 'b' , these groups will map the location folder I need to create, lets say:
blue = c:\test
green = c:\test2
yellow = c:\test3
the user ID will be the file name. The user needs to have the modify permissions to that new folder (aka the userid).
Now I need a vba code to handle this I was thinking:
select statement that reads the column 'b' (starting at 2)
grabs the data and a statement that will check to see if the folder exists or not, if not then create it and permission it according to the userID.
My big question is the way I should create and test the folders and give them the permissions (since I have no clue how too lol) Any help would be great!
Thanks a bunch
Here is the following issue I am having:
( I attached a simple example of the possible data )
I would like to scan through the groups in column 'b' , these groups will map the location folder I need to create, lets say:
blue = c:\test
green = c:\test2
yellow = c:\test3
the user ID will be the file name. The user needs to have the modify permissions to that new folder (aka the userid).
Now I need a vba code to handle this I was thinking:
select statement that reads the column 'b' (starting at 2)
grabs the data and a statement that will check to see if the folder exists or not, if not then create it and permission it according to the userID.
My big question is the way I should create and test the folders and give them the permissions (since I have no clue how too lol) Any help would be great!
Thanks a bunch