Detect Previous Add-In Version

[Stephen Lloyd]

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!

 

[Charles Williams]

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

 

[Bob Phillips]

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.