| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I close a file system object?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I close a file system object?
Workbooks(file.Name).Close SaveChanges:=True
-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Steph" 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I close a file system object?
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" 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I open an Excel file on XP system, saved on a Vista system | Excel Discussion (Misc queries) | |||
| Close Excel server after activating OLE object | Excel Discussion (Misc queries) | |||
| When i close a object 91 error shows. | Excel Programming | |||
| How to close embedded excel object? | Excel Programming | |||
| File System Object | Excel Programming | |||
Linear Mode
