Saving Procdb.xla on exit from Excel
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
|