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.

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

On Tue, 5 Dec 2006 13:51:12 -0500, Paul_B <pb_public-(E-Mail Removed)>
wrote:

>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.

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" <pb_public-(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.

On Tue, 05 Dec 2006 10:59:53 -0800, Gord Dibben wrote:

> 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
>
> On Tue, 5 Dec 2006 13:51:12 -0500, Paul_B <pb_public-(E-Mail Removed)>
> wrote:
>
>>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.


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.

On Tue, 5 Dec 2006 21:08:56 +0200, Arvi Laanemets wrote:

> 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" <pb_public-(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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.


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

p.

Paul

Apologies for the "Pauk"

Gord


On Tue, 5 Dec 2006 18:09:04 -0500, Paul_B <pb_public-(E-Mail Removed)>
wrote:

>On Tue, 05 Dec 2006 10:59:53 -0800, Gord Dibben wrote:
>
>> 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
>>
>> On Tue, 5 Dec 2006 13:51:12 -0500, Paul_B <pb_public-(E-Mail Removed)>
>> wrote:
>>
>>>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.
>
>
>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

On Tue, 05 Dec 2006 15:33:48 -0800, Gord Dibben wrote:

> 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.