XLA Question

[dgillz]

I have written a fairly complex .xla (excel add-in) in VBA. When I add it to each machine, it gets copied to the c:\users\{Username}\Appdata\Roaming\Microsoft\Addins folder. (This is for windows 7, it is a bit different on XP).

So now when I need to make a change to the .xla code, I have to unload and reload the .xla from every frickin' machine. Is there a good way to automatically load the changes down to the client machine?

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[xlbo]

via group policy?
Excel is unfortunately not a distributed system - it si locally stored and configured and therefore doesn't really have any concept of client / server

Happy to be proved wrong but I think best bet for this is to write a script via group policy to enable this

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question