I keep updating an Add-in for my users every few weeks. each time I call it
with it's new version name (started with Power1.0.xla , but now already
Power5.3.xla)

Is there a way I can put a code on my users workbook - let say on Sub
Workbook_Open() to check that the user has the last add-in version - and if
he/she does not to install the last version for him/her (the add-ins are
saved on a shared drive - so they all have access to it).

Many thanks

Dan

How would the code know what the latest version actually is?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Dan" <(E-Mail Removed)> wrote in message
news:E4680974-EA08-4E29-9228-(E-Mail Removed)...
>I keep updating an Add-in for my users every few weeks. each time I call it
> with it's new version name (started with Power1.0.xla , but now already
> Power5.3.xla)
>
> Is there a way I can put a code on my users workbook - let say on Sub
> Workbook_Open() to check that the user has the last add-in version - and
> if
> he/she does not to install the last version for him/her (the add-ins are
> saved on a shared drive - so they all have access to it).
>
> Many thanks
>
> Dan

You may want to reconsider some of your decisions (including the naming
convention) and read

http://www.jkp-ads.com/Articles/UpdateAnAddin.asp
From Jan Karel Pieterse's site.

(He has a demo file there to make life simpler!)

Dan wrote:
>
> I keep updating an Add-in for my users every few weeks. each time I call it
> with it's new version name (started with Power1.0.xla , but now already
> Power5.3.xla)
>
> Is there a way I can put a code on my users workbook - let say on Sub
> Workbook_Open() to check that the user has the last add-in version - and if
> he/she does not to install the last version for him/her (the add-ins are
> saved on a shared drive - so they all have access to it).
>
> Many thanks
>
> Dan

--

Dave Peterson

I have a sheet called VersionList.xls where in column A I have the list of
all versions - the last entry is the most current one.

"Chip Pearson" wrote:

> How would the code know what the latest version actually is?
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting
> www.cpearson.com
> (email on the web site)
>
> "Dan" <(E-Mail Removed)> wrote in message
> news:E4680974-EA08-4E29-9228-(E-Mail Removed)...
> >I keep updating an Add-in for my users every few weeks. each time I call it
> > with it's new version name (started with Power1.0.xla , but now already
> > Power5.3.xla)
> >
> > Is there a way I can put a code on my users workbook - let say on Sub
> > Workbook_Open() to check that the user has the last add-in version - and
> > if
> > he/she does not to install the last version for him/her (the add-ins are
> > saved on a shared drive - so they all have access to it).
> >
> > Many thanks
> >
> > Dan
>

This is for an add-in that is saved on the net, mine is saved on the server.

"Dave Peterson" wrote:

> You may want to reconsider some of your decisions (including the naming
> convention) and read
>
> http://www.jkp-ads.com/Articles/UpdateAnAddin.asp
> From Jan Karel Pieterse's site.
>
> (He has a demo file there to make life simpler!)
>
> Dan wrote:
> >
> > I keep updating an Add-in for my users every few weeks. each time I call it
> > with it's new version name (started with Power1.0.xla , but now already
> > Power5.3.xla)
> >
> > Is there a way I can put a code on my users workbook - let say on Sub
> > Workbook_Open() to check that the user has the last add-in version - and if
> > he/she does not to install the last version for him/her (the add-ins are
> > saved on a shared drive - so they all have access to it).
> >
> > Many thanks
> >
> > Dan
>
> --
>
> Dave Peterson
>