Using the user profile variable for a document template path

[Itsjustbeej]

Hi folks,



My company has a toolbar template used for specific documents we write. IT wants to push it to each user via OneDrive, which means the path to the toolbar will be different for each user. Something like this:

C:\Users\username\Regulatory - Templates\Toolbar.dotm

Where username is the user's login name. I know we should be able to do this using the %USERPROFILE% variable, but when I've tested it on my machine it doesn't work. Thus, currently

C:\Users\myname\Regulatory - Templates\Toolbar.dotm

works (where myname = my actual login name), but if I put in

C:\Users\%USERPROFILE%\Regulatory - Templates\Toolbar.dotm

it doesn't. I get an error that the template can't be found.

What's the correct syntax, or what do I need to change to make this work?

Thanks in advance,

Beej

[gmayor]

The following should work for you

Dim FSO As Object
Dim sDoc As String
    sDoc = Environ("USERPROFILE") &  "\Regulatory - Templates\Toolbar.dotm"
    'MsgBox sDoc
    Set FSO = CreateObject("Scripting.FileSystemObject")

    If FSO.FileExists(Environ("USERPROFILE") &  "\Regulatory - Templates\Toolbar.dotm") Then
        Documents.Add sDoc
    Else
        MsgBox "The toolbar template is not found"
    End If
    Set FSO = Nothing

[Itsjustbeej]

That's great, but I guess I needed to provide more detail. We have about 125 documents which use this toolbar. What I need, I think, is the correct syntax for use in the Templates and Add-ins "Document template" field. Currently I have the path hard-coded so that every one of these documents looks in:

C:\Users\myloginname\Regulatory - Templates\Author.dotm

for the Document Template. It works for me, but I have over 130 users and we can't have each person change the location to their user name, plus as the document is passed from user to user each person will have to change it again.

I've attached a screen shot to show how it's configured on my machine. Basically I want to replace "myloginname" with the %USERPROFILE% variable in that field so it changes from user to user.

Thanks again for any help you can provide.

[macropod]

Cross-posted at: Incorporating the User Profile location into a document template path | Microsoft Office Forums
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters

[Charles Kenyon]

Consider using the Workgroup Templates settings which can be accessed in vba.

Options.DefaultFilePath(wdWorkgroupTemplatesPath)