Templates in excel start folder not working

R

Rick Lowe

I'm developing an excel app which stores it's code in a template. I would like to place this template somewhere that is visible to all users, which the excel documentation suggests is the "xlstart" folder. When I place my template in this folder it does appear in the list when I try to create a new document, but I can not actually create a document from it (clicking on the template name has no effect).

Any ideas on what's going on?

The same template works fine if I put it under my documents and settings template directory.

I'm using Excel 2003 Pro SP1.

- Rick
 
D

Dave Peterson

Do you have a common network share that you can use?

MSOffice has a Workgroup templates location that excel can use--but excel can't
change.

If you open MSWord, you can do:
tools|options|file locations
and set that workgroup templates location to the network path you want.

You can also get to this if you use the MSOffice shortcut bar
Rightclick on an open spot|customize|settings tab


===
If not, I think I'd store the template file in the Templates folder.

Open excel
hit alt-f11
hit ctrl-g
and type this in and hit enter:
?application.TemplatesPath

for me (xl2002 and win98), I get:
C:\WINDOWS\Application Data\Microsoft\Templates\
 
Top