I declared NEW command objects in ADO sometimes they may not be referenced in subroutine. Do they still need to SET to Nothing? And if I set the command objects to Nothing but they weren’t referenced will it cause an error? How does New works for a Command Object? Does it automatically create an instance before it goes into the procedure?

Dim cmd_obj As Command

Set cmd_obj = NEW ADODB.Command

If ret.value =1 then
cmd_obj
else
..


Thanks!!