Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I recover an Excel document saved not saved as | Excel Discussion (Misc queries) | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
arrays - module to module | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |