I have decided to use fully qualified references to OLE Automation Libraries---even those considered "default" like the VB, VBA and Application objects. I do this because Microsoft says it does not hurt (it may improve performance slightly) and it allows me to take advantage of the "Intelligent" features of my IDEs. It is also an ongoing educational tool.
So in my Visual Basic 6.0 code, something like following will not be uncommon:
If VBA.VarType(StartCol) <> vbLong Then
VBA.Err.Raise 450
End If
By using fully qualified references, I can also see some of the "mystery" objects out there. For example, Debug is not a VBA object. And I thought for sure that the Open statement for file access was VBA method. But this does not seem to be the case.