FileSystemObject close method 2

[TempestT37]

Hello group
Is there any difference between the two lines below?
Which is better to use?

fso.Close()
Set fso = Nothing

Thank Michael

 

[onpnt]

both should be used
first one (set = nothing) refers to the object that you created
the second refers to the file opened in which you need to close

so psuedo is
Set object = Nothing

File (TextSteam).Close


____________________________________________________
[sub]get the best answer to your questions by asking the best questions "General FAQ" faq333-2924[/sub]

[sub][sup]

http://www.onpntwebdesigns.com

[/sup][/sub]

 

[TempestT37]

I keep getting “Object required” .
Can you see what I am doing wrong?


<%
fileName = Request(&quot;fileName&quot
Set fso = CreateObject(&quot;Scripting.FileSystemObject&quot
Set fileObject = fso.GetFile(&quot;d:\webs\cent44\data\&quot;& fileName &&quot;&quot
Set textStreamObject = fileObject.OpenAsTextStream(1,0)
newInfo = textStreamObject.ReadAll
Set textStreamObject = Nothing
'textStreamObject.Close
Set fileObject = Nothing
'fileObject.Close
fso.DeleteFile(&quot;d:\webs\cent44\data\&quot;& fileName &&quot;&quot
Set fso = Nothing
fso.Close %>

 

[JamesLean]

You need to .Close it before you set it to Nothing.

--James

 

[TempestT37]

The only one that need to worry about is textStreamObject, right? I hope so when I try the other two (fileObject and fso) I get errors.

Michael

textStreamObject.Close
Set textStreamObject = Nothing
'fileObject.Close
Set fileObject = Nothing
fso.DeleteFile(&quot;d:\webs\cent44\data\&quot;& fileName &&quot;&quot
'fso.Close
Set fso = Nothing

 

[JamesLean]

Yes. Any variable that is Set to an object instance should always be set to Nothing at the end.

Additionally, if an object has been .Opened then you should .Close it as well.

--James

 

[DreXor]

recommended to close it before setting it to nothing, because you cant close it after the object has been destroyed