How do I close a file system object?

[Steph]

I have a file opened using a file system object in a macro. How do I close
the file? file.close doesn't work.
Thanks

[Jim Cone]

Workbooks(file.Name).Close SaveChanges:=True
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Steph" <[email protected]>
wrote in message...
I have a file opened using a file system object in a macro. How do I close
the file? file.close doesn't work.
Thanks

[NickHK]

Steph,
Not that I use the FSO in VBA (as I have never found a need for it), the
ObjectBrowser indicates that the .OpenTextFile function returns a TextStream
object.
The TextStream object then has a .Close method.

NickHK

"Steph" <[email protected]> wrote in message
news:[email protected]...
> I have a file opened using a file system object in a macro. How do I close
> the file? file.close doesn't work.
> Thanks