Vista - Set homeDrive and homeDirectory from excel spreadsheet

02-27-2009

I have a set of scripts that I've got worked out to create profile and home
folders then set the Terminal Server Profile path and home drive and path.
The last piece of the puzzle is I want to set the regular homeDrive and
homeDirectory attributes in AD via the same script and excel file. I've
tried various methods (objUser.PUT and objUser.Homedirectory) and none of
them seem to be working correctly. Does anybody have any ideas?

03-03-2009

"Johnathan" <Johnathan@xxxxxx> wrote in message
news:4DB6A111-5D80-466D-9BCC-35476107DCFE@xxxxxx

Quote:

>I have a set of scripts that I've got worked out to create profile and home
> folders then set the Terminal Server Profile path and home drive and path.
> The last piece of the puzzle is I want to set the regular homeDrive and
> homeDirectory attributes in AD via the same script and excel file. I've
> tried various methods (objUser.PUT and objUser.Homedirectory) and none of
> them seem to be working correctly. Does anybody have any ideas?

This example is for creating users from a spreadsheet but it might help:

http://www.rlmueller.net/CreateUsers.htm

The value of homeDrive should have the semicolon, for example "H:". Search
the script for strHomeDrive and strHomeDirectory to see how it is handled.
The script creates the home directory if it does not exist. You may not need
that. Also the script runs cacls to assign permissions for the user.

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--

02-27-2009	#1 (permalink)
Johnathan n/a posts	Set homeDrive and homeDirectory from excel spreadsheet I have a set of scripts that I've got worked out to create profile and home folders then set the Terminal Server Profile path and home drive and path. The last piece of the puzzle is I want to set the regular homeDrive and homeDirectory attributes in AD via the same script and excel file. I've tried various methods (objUser.PUT and objUser.Homedirectory) and none of them seem to be working correctly. Does anybody have any ideas?
My System Specs

03-03-2009	#2 (permalink)
Richard Mueller [MVP] n/a posts	Re: Set homeDrive and homeDirectory from excel spreadsheet "Johnathan" <Johnathan@xxxxxx> wrote in message news:4DB6A111-5D80-466D-9BCC-35476107DCFE@xxxxxx Quote: >I have a set of scripts that I've got worked out to create profile and home > folders then set the Terminal Server Profile path and home drive and path. > The last piece of the puzzle is I want to set the regular homeDrive and > homeDirectory attributes in AD via the same script and excel file. I've > tried various methods (objUser.PUT and objUser.Homedirectory) and none of > them seem to be working correctly. Does anybody have any ideas? This example is for creating users from a spreadsheet but it might help: http://www.rlmueller.net/CreateUsers.htm The value of homeDrive should have the semicolon, for example "H:". Search the script for strHomeDrive and strHomeDirectory to see how it is handled. The script creates the home directory if it does not exist. You may not need that. Also the script runs cacls to assign permissions for the user. -- Richard Mueller MVP Directory Services Hilltop Lab - http://www.rlmueller.net --
My System Specs

Similar Threads
Thread	Forum
create Excel spreadsheet without loading Excel	VB Script
Excel Spreadsheet Problem	Microsoft Office
Excel Spreadsheet Help	Software
Adding headers to an excel spreadsheet	PowerShell
EXCEL spreadsheet running slow	Vista performance & maintenance