Search notes:

VBA: creation of objects

In VBA, objects are created with either new or createObject.

new vs createObject

With new, the VBA runtime knows the CLSID (class id) when the object is created.
With createObject, the runtime first has to look up the CLSID via the progId in the registry.
new returns the default COM interface which is specified in the respective typelib.
createObject returns either an IDispatch (if available) or a IUnknown.

Index