Extending product function with VBA : Automation and System Architect : Automation : Summary
  
Summary
Dim object = server.class
Declare server.
Set object = new server.class
Instantiation of server.
Automation code
Microsoft VBA code that accesses server automation objects.
Dim object = nothing
Release Automation server from memory.
See also
Automation