I'm looking for advice and/or code examples on detecting and removing a
previous add-in version. The previous version would be open at the time the
user installs the new version.

Questions:

Is it better to store/use the version number in the file name or somewhere
on a worksheet (or somewhere else)?

Is there anything problematic with this practice?

Thanks in advance for any help!

You might want to look at mu Automatic Reversioning Addin Loader.
http://www.DecisionModels.com/Downloads.htm


Charles
___________________________________
London Excel Users Conference April 1-2
The Excel Calculation Site
http://www.decisionmodels.com

"Stephen Lloyd" wrote in message
...
I'm looking for advice and/or code examples on detecting and removing a
previous add-in version. The previous version would be open at the time
the
user installs the new version.

Questions:

Is it better to store/use the version number in the file name or somewhere
on a worksheet (or somewhere else)?

Is there anything problematic with this practice?

Thanks in advance for any help!

If you used a job-specific installer, you could have script that asks for
Excel to be closed down, and will install over the old version.

--
__________________________________
HTH

Bob

"Stephen Lloyd" wrote in message
...
I'm looking for advice and/or code examples on detecting and removing a
previous add-in version. The previous version would be open at the time
the
user installs the new version.

Questions:

Is it better to store/use the version number in the file name or somewhere
on a worksheet (or somewhere else)?

Is there anything problematic with this practice?

Thanks in advance for any help!