On 2 Jun, 16:38, "Peter T" <peter_t@discussions wrote:
Change related object declarations to "As Object' and
use CreateObject.

I have since found that that isn't as painful as I feared, and I am
part way through doing it (This is a _big_ excel macro),
I found that the declaration CLSIDs are all listed together in Regedit
(unless there is an easier way?) and it is only the dim O as new lines
that need changing.
The vast array of enumerated types are proving annoying, but no worse
than that.

Thanks for the confirmation that I am on the right track.