Re: Software costs?
All my macros have to work throughout the staffs PC's & whatever they send me for approval has to "just work" as well . All the formatting must be according to a standard we decide and control. It has to be managable on a distributed network
That list doesn't contain anything OO or LO cannot handle, with added benefit that you can leave users on any platform and your format will *STILL* look the same. Granted, the macro language needs learning, but at least it works consistently across versions and languages.
It's a waste of time and money to give users too many options. They are there to work
Although you don't exactly sound like fun to work for, I actually agree. But then ask yourself: are you prepared to have them fight with every new version that MS rams down your neck, the main change usually being enough to totally destroy productivity for months? The only bit in OO/LO that could really, really do with a change is the insane colour management. I don't want to have to name a colour for the 3 times in a month I use it. But at 130x nada for license costs I think it's something you may want to reconsider - you save enough money to pay for someone converting your macros.
Having said that - get decent software for that. Office macros are not exactly the most stable platform to base an organisation on..