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" wrote in message
...
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" wrote in message
...
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