I think the deal with VBA is that if you are working just in the VBA of
the
host application, you don't need to be too retentive about closing your
references. However, if you are automating another application or dealing
with COM, then you have to be more careful.

While that is most likely true in the great majority of cases, My reply
would have to be this: Why would you ever not want to cultivate a more
careful approach to programming anyway?

In general I do. I avoid relying on defaults. I declare variables in as
tight a scope as possible and always use Option Explicit. Out of habit I
generally do close all my references explicitly. I write code to be as
modular and insular as possible.

While I was pointing out that certain measures are not always strictly
required, it's probably best that I refrain from doing so.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______