Excel 2003 Fails to open template

G

Geroge

My workgroup templates are Excel97 and Excel 2003 won't open them. No error
it just doesn't open them.

Even if I save a new template in 2003 and save it to the workgroup location
it fails to open. They can be seen in the open dialog box.

The workgroup location is on a Netware, but that shouldn't matter as they
are in P:\MSOFFICE\XLSTART\TEMPLATE

If I move them to the same folder as the Word Templates then they open, but
the File extension is displayed.

This can't be by design.
 
D

Dave Peterson

First, I don't have a network to test--so this is just a suggestion and may not
help.

I'd check the templates path and the network templates path to make sure that
they point to the correct location. (The .templatespath isn't your problem--but
it may be interesting to see???)

You could run a macro and look in the immediate window:

Option Explicit
Sub testme()
With Application
Debug.Print .TemplatesPath & vbLf & .NetworkTemplatesPath
End With
End Sub

If the network templates path points at the incorrect location, you can change
it in MSWord--excel doesn't offer a way to get to that path.

If it points at the correct location, are you sure you're using it correctly.

I'm not sure what you mean by the Open dialog box. I would think you'd want the
File|New dialog (or Task Pane).

If you don't like that task pane, you could use a macro to show the old style
interface:

Option Explicit
Sub testme2()
Application.Dialogs(xlDialogWorkbookNew).Show
End Sub
 
G

Geroge

The Path is set correctly as the templates can be seen in the Open|New
Template Dialog. They just won't open. I can select them without anything
happening.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top