EXCEL Templates

[Grace]

Somehow, my blank template had gotten to be something different than what I
liked, with narrow columns, rows, etc. I have figured out how to change and
save my template, so that when I open EXCEL, the empty template (book 1)
looks like what I want.

However, when I have already opened EXCEL and have some other file open,
when I click on "open a new file icon", or if I run a macro that causes a
new file to be opened (then have data pasted into it), it seems like a
different template file is being opened, one that still looks like the old
ugly one.

Where is the second, non-start up, EXCEL template located so that I can
change it too?

Thx,
Dean

 

[Dick Kusleika]

Grace

Whenever you create a new workbook, Excel should base that new workbook on a
template called book1.xlt in your xlstart directory (if it exists). When
you choose File > New, are you saying you get a different workbook than the
default book1 you get when Excel first starts? If so, and you've already
saved book1.xlt in the xlstart directory, then tell me what version you're
using and I'll see if I can reproduce it.

As for code, I would think that it would work the same way. However, the
Workbooks.Add method has a Template argument that you could use to specify
book1.xlt.

 

[Dean]

Also, this one file that I do like as a new template, now seems to open up
every time I try to open some other file, so that I am getting two files
opening, which is a pain. Can anyone help?

Dean