Saving Procdb.xla on exit from Excel

[JD]

Greetings,
I'm doing some development on an Excel 2002 workbook.
the purpose of the workbook is to analyze some data and
create graphs. I am using the Analysis toolpak addins
for both Excel and VBA.
The code runs correctly and I have no problems there. I
can close the workbook without closing the application
with no trouble, but when I close the application, I get
the following message: "Do you want to save changes to
Procdb.xla". I have no clue where to start on
determining why this .xla file has been modified. I
cannot see this module when I go to the VB editor.

Anyone have any experience with this situation?

thanks


p.s. I've posted this question in the Office developer
forum as well, but hey, I'm just looking for some help.
thx

 

[Jim Rech]

It's okay for an add-in to modify itself but it should never prompt to save
changes. The fact that it does suggests to me that it is not really an
add-in. Is it possible the "IsAddin" property have been changed to False?
You might try uninstalling the Analysis Toolpak and then reinstalling it;
the idea being to get the current XLA deleted and a new original installed.
If you try this make sure the Analysis folder under Office\Library is empty
after the uninstall.

--
Jim Rech
Excel MVP
| Greetings,
| I'm doing some development on an Excel 2002 workbook.
| the purpose of the workbook is to analyze some data and
| create graphs. I am using the Analysis toolpak addins
| for both Excel and VBA.
| The code runs correctly and I have no problems there. I
| can close the workbook without closing the application
| with no trouble, but when I close the application, I get
| the following message: "Do you want to save changes to
| Procdb.xla". I have no clue where to start on
| determining why this .xla file has been modified. I
| cannot see this module when I go to the VB editor.
|
| Anyone have any experience with this situation?
|
| thanks
|
|
| p.s. I've posted this question in the Office developer
| forum as well, but hey, I'm just looking for some help.
| thx

 

[Guest]

Jim,
thanks for the reply. The file must be part of the
analysis toolpak. It resides in the 'Analysis' folder of
the office\library directory. It is password protected,
and I'm not enough of a hacker to even try to guess what
password Microsoft uses for that .xla file. I tried to
look at the properties, but couldn't. I did the
uninstall of the entire Office suite. This definately
removed the addins from the library folder, but made no
difference when I re-ran my code.

any other ideas?

 

[Jim Rech]

I can't think of anything else. The truth is, if I wanted to get the
warning you're seeing I wouldn't know how!

--
Jim Rech
Excel MVP
| Jim,
| thanks for the reply. The file must be part of the
| analysis toolpak. It resides in the 'Analysis' folder of
| the office\library directory. It is password protected,
| and I'm not enough of a hacker to even try to guess what
| password Microsoft uses for that .xla file. I tried to
| look at the properties, but couldn't. I did the
| uninstall of the entire Office suite. This definately
| removed the addins from the library folder, but made no
| difference when I re-ran my code.
|
| any other ideas?
|
| >-----Original Message-----
| >It's okay for an add-in to modify itself but it should
| never prompt to save
| >changes. The fact that it does suggests to me that it
| is not really an
| >add-in. Is it possible the "IsAddin" property have been
| changed to False?
| >You might try uninstalling the Analysis Toolpak and then
| reinstalling it;
| >the idea being to get the current XLA deleted and a new
| original installed.
| >If you try this make sure the Analysis folder under
| Office\Library is empty
| >after the uninstall.
| >
| >--
| >Jim Rech
| >Excel MVP
|