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" <(E-Mail Removed)> wrote in message
news:C5786F49-2781-4B1B-804C-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:C5786F49-2781-4B1B-804C-(E-Mail Removed)...
> 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!