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?

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\C ommon\General\SharedTempla
tes

--
Jim Rech
Excel MVP

Jim Rech wrote:
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\C ommon\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! :)

Try changing it in MSWord.

xl2002 finds the location that way.

Sonny Maou wrote:

Jim Rech wrote:
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\C ommon\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

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

"Dave Peterson" wrote in message
...
Try changing it in MSWord.

xl2002 finds the location that way.

Sonny Maou wrote:

Jim Rech wrote:
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\C ommon\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

Jim,
According to:
http://msdn.microsoft.com/library/de...us/modcore/htm
l/deovrDeployingTemplatesApplicationSpecificAddins.a sp

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


"Jim Rech" wrote in message
...
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\C ommon\General\SharedTempla
tes

--
Jim Rech
Excel MVP

Nick-

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

HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Co mmon\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.

--
Jim Rech
Excel MVP

Jim,
Thanks for your help. Got it sorted now.

NickHK


"Jim Rech" wrote in message
...
Nick-

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


HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Co mmon\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.

--
Jim Rech
Excel MVP