first_page the funky knowledge base
personal notes from way, _way_ back and maybe today

OLE Automation: Using Fully Qualified References for Libraries Considered "Default"

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.

mod date: 1999-02-05T17:59:32.000Z