asked on

Using Username in a Path in a VBS Script

As part of our VBS login script, we use it to copy templates from a network share to the local machine. The code compares the date of the file on the local machine to the file on the network, if it's older, it copies down the current one. The script uses/reads a text file to determine which documents to copy. Currently the files are copied to a static location in c:\program files. What I'm trying to do is copy the templates to each user's profile. What I can't figure out is how to impliment the code so it will enter the current user into the path.

The current code that does the copying looks like this:
t="C:\program files\"&lines(i)
(the rest of the path is contained in the text files called by &lines)

What I would like to be able to do:

t="C:\Users\%username%\"&lines(i)

I know that you can't use environ variables in VBS, I put that in there as an example.

I'm using the following code to set the variable, though Im not positive it's correct either.

Set Network = CreateObject("WScript.Network")
CurrentUser = Network.UserName

I can provide more code if needed,

Thanks

Bill Prew

You are there, just do the following to concatenate the username to the rest of the needed path:

Set Network = CreateObject("WScript.Network")
CurrentUser = Network.UserName
t = "C:\Users\" & CurrentUser & "\" & lines(i)

Open in new window

~bp

gthmpd

ASKER

Thanks Bill for the prompt reply!

No Errors this time, but not the results I was looking for. IE the file didnt copy down. Would it be possible to send you my Script to look at?

Bill Prew

Sure.

~BP

gthmpd

ASKER

Hey Bill,

I've attached the code i'm trying to modify. In the 1st part is the code we used to copy templates from the network to a Win Xp computer. In the Program Files\Microsoft Office\ Folder.

What I want to do now is copy those same templates to a Win7 users profile. (2nd Part)

I've highlighted the parts i'm focusing on, the old code in green. The new code is in yellow. I know that in the new code, where it sets the permissions is messed up, not sure how to do that either.

Thanks for taking a look.

JS
Copy-of-RASScript64.docx

ASKER CERTIFIED SOLUTION

Bill Prew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gthmpd

ASKER

Thanks again, I had to alter the path for the move text file a little, but the code for the win7 info works fine.