Quote Originally Posted by xlnitwit View Post
......... There is no native VBA.Dictionary incidentally, though it is of course possible to create your own class called Dictionary, which is why I used the phrase "in this case".
Thanks. That clears that up. I expected that was the answer, but nice to get a confirmation,

-....
(_.....
Quote Originally Posted by xlnitwit View Post
........... can be sure of that because removing the reference to the Scripting runtime makes the Dictionary code fail. When you declare a variable as Dictionary, the compiler will check the available references to locate the correct object. ...
I guess I was thinking that there might be two similar Objects in the Microsoft Scripting Runtime Library, that is probably talking rubbish ? .
.._ )


_......



So it follows that the decrepancy I got was just, as I thought, that VBA sometimes recognises Dictionary as Scripting.Dictionary and sometimes not.
But as you say, it ls always exactly the same thing ( Object )
Thanks
Alan