Can This be Done?

[AzazelOz]

Hi all,
Sorry I am only learning VB Script now but have a query I would like to know
if it would be possible or just too much work to do.
What I would like is a script that queries an excel spreadsheet for usernames
that we add manually to the spreadsheet.
I then want the script to grab each username from the spreadsheet & query
active directory for the users home drive. I then would like the script to goto
the path specified in the home drive & copy the users home drive to a
different location on the network (can be hard coded etc as wont change).
Then once complete I would like the script to verify the data has all copied
& then delete the original data.
Also would need a log file that tracks all this & confirms everything & spits
out any errors along the way. I.e user has no home directory etc.

Also would be good if I can do this so the script queries Lotus Notes address
book for mail server & does the same thing with the mailfile but one step at
a time I think.

Any help or just advice on if this could be done & if it might take two months
to make or maybe how much work would be involved then I can decide to look
elsewhere or if vb script will do what I need.

Thanx for any replies.

[mendhak]

Yes, possible. And yes, it'll take a lot of effort. You should look into using VB6 or VB.NET for this.

[techgnome]

It'll take SOME effort, but not as much as menhack made it out to be... but it would be more than doing it in VB for sure.

Tg

[AzazelOz]

Ok people thanx for your replies.