How do you really destroy an object?

[VBGuy2112]

This is part curiousity and part "need to know for my web page programming style". How do you really destroy an object so that you could dimension it again?

For example:

Dim objConn ' Database connection

objConn.Open .......
objConn.Close

Set objConn=Nothing


Dim objConn

blah blah blah


The reason why I want to dimension the variable again is because I use include files to do a lot of things and I would like for them to dimension their own objects and then destroy them (like functions in visual basic). I don't want to have to think of different object names for every file.

Is there a way to do this? Setting it equal to nothing doesn't seem to destroy it to the point that I could redim it.

Thanks!

 

[SashiRaveendran]

you cant dim something twice in the same function or method, you can only do it once, once dimmed you can set it to what you want (nothing, object, string whatever).