"SandyUK" wrote in
message ...

Hi Bob

These workbooks were created by a predecessor and have been in use for
7 years and unfortunatly people have saved them all over the place.
They calculate data which is then manually entered all over the place
etc etc. I guess what i am saying is that I can't get to all the old
versions to delete them and because they still work and people being
people just have shortcuts etc they are not keen to delete them or see
any point in upgrading (to them its a matter of a couple of pence per
product which is not a big deal but in the overall scheme of things its
getting towards the £1m mark).

It would seem to me that if it is getting twiards the £1M mark, you have an
irrefutabel business case.

My company has issues with Add ins and at the moment are upgrading to
2003 (slowly) so even more problems keeping the add in available to all
the machines (again easy enough to do but i am dealing with some users
(across multiple locations that i can't get to) who would rather cut
there own foot off than do anything "techie" then shout when they
couldn't walk any more because they appear to be missing a foot).

Whjy would they have issues with add-ins, but not VBA in the workbook. The
former makes more sense than the latter, and is more controllable.

Suffice to say i am between a rock and a hard place. I need a self
contained workbook which on start up will look to see if it the latest
version and then display a message saying it isn't (if it isn't) but
"if you go to X or call Y" they can get the latest version then close
down (i know i will have to force people to enable macro's but i have
that covered at the momet)

Do you mean separate from the multi-version workbook? What I am missing at
the moment is how you will be able to amend all of these workbooks when you
say you can't get to them all. If they were all named the same, you could
install a new addin on each machine (same old problem her though) which has
application events that monitor files being opened, if our offending
workbook opens, you could dump the code and automatically load the
up-to-date code. A dictator application if ever I heard one!