Macro-programming Office documents is one of those things that should immediately elicit the question "Is there a better solution?" There almost always is. Office documents are an extremely poor workflow and a terrible artifact for data.

Which is why replacements seldom have more than the most trivial of automation -- the people who are making the move usually change their workflows. The offices that built around Office 95 are, however, still doing things the way they always do.

EDIT: What a changed world when this is a contentious comment.