Solved: Can't Create an Excel Default Workbook Template

[Cyberdude]

For some reason I have so far been unable to create a default Excel workbook template. I know that the extension must be ".xlt", and that a default workbook template should be stored in "... \XLStart".
Help didn't mention what it should be named, but J. Walkenbach said to name a default workbook template "Book.xlt" and a default sheet template "Sheet.xlt". I did all that, but when I request a new workbook, I get the standard one that Excel always creates. I couldn't find an ".xlt" file that seemed to be the Excel default. What am I missing?

[Desert Piranha]

Hi,
My custom default workbook works fine as Book.xlt in:
C:\Documents and Settings\Owner\Application Data\Microsoft\Excel\XLSTART

For some reason I have so far been unable to create a default Excel workbook template. I know that the extension must be ".xlt", and that a default workbook template should be stored in "... \XLStart".
Help didn't mention what it should be named, but J. Walkenbach said to name a default workbook template "Book.xlt" and a default sheet template "Sheet.xlt". I did all that, but when I request a new workbook, I get the standard one that Excel always creates. I couldn't find an ".xlt" file that seemed to be the Excel default. What am I missing?

[Cyberdude]

Hi, Piranha! That's probably my problem. I didn't show the path, but I'm using:
C:\Program FIles\Microsoft Office\Office11\XLStart
That's the path that was recommended for a default template. The path you used is for what they called a "custom" template. I assumed that the custom template would not be used unless specifically summoned. I'll give your path a try. Thanx.

[Bob Phillips]

Do ?application.StartupPath in the immediate window to get the path.

[Desert Piranha]

Hi,
Yeah, the path i posted causes the workbook to open with Excel, on my system. After i made my changes i wanted, on the workbook, i saved it as Book.xlt, at that path. Works fine.

Hi, Piranha! That's probably my problem. I didn't show the path, but I'm using:
C:\Program FIles\Microsoft Office\Office11\XLStart
That's the path that was recommended for a default template. The path you used is for what they called a "custom" template. I assumed that the custom template would not be used unless specifically summoned. I'll give your path a try. Thanx.