I guess this old dog has to learn another new trick.

It has become obvious that in addition to learning more VBA, I will have to learn AppleScript. That's not a bad thing, because it is a system language and can be used with almost any Mac application.