Default template management problem

[Paul_B]

Hi,

I'm new to Excel, '03. I've set up a default template, book.xlt,
in the xlstart folder, and excel is reading it properly.

Now I want to add some macros. Problem is, when I open the VB
editor, Insert a Module, then try to save it, the VB editor
prompts me to save it as a new file rather than part of book.xlt.
If I try to overwrite book.xlt, of course it won't let me because
that file is still open in excell; if I try to first close that
file the VB editor closes with it. So I'm stuck.

Obviously I'm missing something basic.

Thanks,
p.

 

[Gord Dibben]

Pauk

Close Excel and workbooks.

Using Windows Explorer browse to the xlstart folder and open book.xlt from
there.

It will open as book.xlt(not *.xls)

Make your changes and then save.

OR just open in the regular manner, make your changes then File>Save As>File
Type>template(*.xlt)

Overwrite the original book.xlt


Gord Dibben MS Excel MVP

 

[Arvi Laanemets]

Hi

You don't need to save in VBA editor anything - this feature there is meant
for export of code. Simply write your code and close VBA editor. But don't
forget to save your workbook afterwards - it is when all your changes in
code are saved too.


Arvi Laanemets

 

[Paul_B]

Pauk

Close Excel and workbooks.

Using Windows Explorer browse to the xlstart folder and open book.xlt from
there.

It will open as book.xlt(not *.xls)

Make your changes and then save.

OR just open in the regular manner, make your changes then File>Save As>File
Type>template(*.xlt)

Overwrite the original book.xlt

Gord Dibben MS Excel MVP

Thanks much, Gord. Using this method I was able to save the VB
work with no problem. Now to get my macro to work.

p.

 

[Paul_B]

Hi

You don't need to save in VBA editor anything - this feature there is meant
for export of code. Simply write your code and close VBA editor. But don't
forget to save your workbook afterwards - it is when all your changes in
code are saved too.

Arvi Laanemets

Thanks. For some reason I couldn't get this to work, so I did it
the long way, by opening the template directly.

p.

 

[Gord Dibben]

Paul

Apologies for the "Pauk"

Gord

Thanks much, Gord. Using this method I was able to save the VB
work with no problem. Now to get my macro to work.

p.

Gord Dibben MS Excel MVP

 

[Paul_B]

Paul

Apologies for the "Pauk"

Gord

No problem. I've been working such long days that I don't even
think I noticed it.

p.