Changes not saved in xla module
 

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

Changes not saved in xla module
 

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

--
Regards,
Tom Ogilvy



"Ajtb" wrote in message
...
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

Changes not saved in xla module
 

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

Changes not saved in xla module
 

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" wrote in message
...
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).