Hi Tony,
Excel add-ins are quite prevalent in larger corporations. They are
mostly used to either add functionality to Excel that it doesnt
already possess, attach Excel to BE databases for referential data
that they dont want to Pivot but use more like a VLookup, and of
course automating / templating analytical reports. One I am working on
right now (Super urgent - got to have it yesterday!) is a set of
wizards to simplify complex graphing procedures (MariMekko, Quadrant
Bubble, Heat Charts, etc...). The issue with Excel add-ins is that
there is no version control, same as there is for FE's. When you make
an update you have to rely on the user to swap out the file for
the .xla (before Excel is running).
In theory you could program a 'main' button on a toolbar to do file
checking before activating the real .xla, but there are serious
inconsistancies between versions of Excel in the way this is handled.
In my corporate environment we have a mix of 2000, XP (2002), 2003,
2007. If we include some of our business partners in the mix we range
from 97 to 2010. You cant cover every contingency with a single
'standard' approach in Excel, but you can cover most and my office
environment is running the add-ins fine. The only way I can guarantee
that the macro that is being used is kept up to date is to hand it to
our IS group to turn into an .MSI installer each time a change is
made. This is massive overkill, expensive (~€1000 per .msi), and takes
a long time to implement. In short, handling .xla files through the
Updater, combined with Access FE and BE files, and maybe even other
office add-ins (we have some for Powerpoint and Word too), template
files and so forth, IMO you would be on to a definite winner. It
wouldn't take much (it seems) to place some simple 'end user' type
management for these additional file types. I am thinking that a
complete non-technical person could theoretically managa things here
(or as close as possible - high school aint what it used to be).
An application like that, which allows people / offices to customise
their office setup and maintain some standards at the same time would
be a real boon. At the moment I am using some simple scripts for
managing the other add-ins, but it is not particularly elegant. An
integrated Updater would do the job nicely. In theory you can do it
now, its just not clean so to speak.
I hope this helps
The Frog