>The worst disappointment was the Office automation. Not because it's inconsistent, memory hungry, slow or clumsy (it is all of that), it's that it's a house on sand. Whatever you do may not work with the next version. I have VFP code, parts of which were written in 1989, which still works. Most of the automation code had to be reworked over and over, because of this particular type of software rot.
Not sure why that would be. Whatever you do in FoxPro you can also do with .NET and the `dynamic` type. I think if you use the actual strongly typed automation libraries, they are scoped to a very particular version of the SDK which in turn is usually scoped to a specific version of Office.
But you can dynamically create COM objects, and use `dynamic` in the same way we do it in FoxPro and not be dependent on specific versions. Same COM instantiation and same late COM binding.
IOW COM is COM - doesnt' matter where you use it from.