DeleteFile Method

[don]

I have a db IV file passed to Excel from Approach.
I need to delete the file once I have copied the data into excel.

Excel Help says:

object.DeleteFile filespec[, force]

object Required. Always the name of a FileSystemObject.

I have no idea what the FileSystemObject would be.

Any help would be appreciated.

Thanks
Don

 

[Jim Cone]

Don,

You got into the help file for the Microsoft Scripting Runtime.
Its script works seamlessly with Excel.
However, using VBA the "Kill" statement will remove a file.
It cannot be used to delete an open file.
The syntax is very simple...

Kill "MyFileName.xls"

Note: do not use a wild card character in the file name as you
could delete every xls file in the folder.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"don" <[email protected]>
wrote in message
I have a db IV file passed to Excel from Approach.
I need to delete the file once I have copied the data into excel.

Excel Help says:

object.DeleteFile filespec[, force]

object Required. Always the name of a FileSystemObject.

I have no idea what the FileSystemObject would be.

Any help would be appreciated.

Thanks
Don

 

[don]

Thanks jim, works great.