Changes not saved in xla module

[Ajtb]

Hi
I run workbooks which make reference to a Module.xla. I have just
noticed that when I run one of the workbooks first to test some code,
make some changes, and then save the updated code in Module.xla, I find
the changes were not saved when I next start Excel up again. Excel
appears to be functioning normally.

When I just load the code book, Module.xla, make and save changes to the
coding, those changes will be saved. When I next start Excel up again,
the changes are there.

Is this an Excel glitch ?

I am using Office 2000 pro on Windows xp pro sp2.
I have removed Office 2000 and then reinstalled it with no improvement.
I have checked to see that Module.xla is not set to read only.

I am an experienced programmer with 4 to 5 years of writing code behind
me but I can't remember seeing this problem before.

Anybody got any ideas ?

TIH

Andrew Bourke

[Tom Ogilvy]

How do you specifically save the Addin after making changes (in the case
where it doesn't work).

--
Regards,
Tom Ogilvy



"Ajtb" <[email protected]> wrote in message
news:[email protected]...
> Hi
> I run workbooks which make reference to a Module.xla. I have just
> noticed that when I run one of the workbooks first to test some code,
> make some changes, and then save the updated code in Module.xla, I find
> the changes were not saved when I next start Excel up again. Excel
> appears to be functioning normally.
>
> When I just load the code book, Module.xla, make and save changes to the
> coding, those changes will be saved. When I next start Excel up again,
> the changes are there.
>
> Is this an Excel glitch ?
>
> I am using Office 2000 pro on Windows xp pro sp2.
> I have removed Office 2000 and then reinstalled it with no improvement.
> I have checked to see that Module.xla is not set to read only.
>
> I am an experienced programmer with 4 to 5 years of writing code behind
> me but I can't remember seeing this problem before.
>
> Anybody got any ideas ?
>
> TIH
>
> Andrew Bourke

[Ajtb]

Hi Tom - thanks for your reply.

I save the Addin by clicking on the disk icon on the standard toolbar in
the visual basic editor. I make sure first that the floating message
tells me it will save Module.xla.

Regards
Andrew Bourke

Tom Ogilvy wrote:
> How do you specifically save the Addin after making changes (in the case
> where it doesn't work).
>

[Tom Ogilvy]

I agree that that should doit.

Another thing I do is go to the immediate window and do

workbooks("MyAddin.xla").Save

--
Regards,
Tom Ogilvy

"Ajtb" <[email protected]> wrote in message
news:[email protected]...
> Hi Tom - thanks for your reply.
>
> I save the Addin by clicking on the disk icon on the standard toolbar in
> the visual basic editor. I make sure first that the floating message
> tells me it will save Module.xla.
>
> Regards
> Andrew Bourke
>
> Tom Ogilvy wrote:
> > How do you specifically save the Addin after making changes (in the case
> > where it doesn't work).
> >