Application.NetworkTemplatesPath Not Working

[Sonny Maou]

In Word, I can see the "workgroup templates" path is set. However, Excel
apparently doesn't see it. Are there any known issues with
Application.NetworkTemplatesPath() not returning the specified path?

 

[Jim Rech]

I believe a shared path has to be set in the registry. For Excel 2003 it
seems to be:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\General\SharedTempla
tes

 

[Sonny Maou]

I believe a shared path has to be set in the registry. For Excel 2003 it
seems to be:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\General\SharedTempla
tes

Good clue. I checked my system and I'm running Word 2002 (10.0), so the
shared template path specified there doesn't get put into the
SharedTemplate registry entry to Excel 2003 (11.0).

Thanks!

 

[Dave Peterson]

Try changing it in MSWord.

xl2002 finds the location that way.

 

[Nick Cranham]

Jim,
According to:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/htm
l/deovrDeployingTemplatesApplicationSpecificAddins.asp

Application.NetworkTemplatesPath = "\\Server\Share\WorkgroupTemplates" sets
the value. However, this property is Read Only.

Also, using Office 2000, I can find no Registry entry relating Excel's
network paths.

Any help appreciated.

NickHK

 

[Nick Cranham]

Dave,
Thanks, managed to set it, but none of those templates are coming up when
New is selected, only from the local templates folder.

NickHK

 

[Jim Rech]

Nick-

I've found that if you manually add the registry key:

HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Common\General\SharedTemplat
es

then Excel 2000 will include templates it finds on that path.

You have to use the Regedit.exe program to add this entry, which you can
start from Start->Run.

 

[Sonny Maou]

Try changing it in MSWord.

xl2002 finds the location that way.

Well, I'm using xl2003! That's why it didn't/wouldn't work that way.