Delete a File Using VBA 1

[cranebill]

If i wanted to delete a file using VBA and i know the path,filename, and extension, how would i go about doing this?

Bill

 

[psemianonymous]

Look up help on the Filesystem object.

Filesystem.Kill "fullfilename"

 

[cranebill]

Solution:

Kill "complete path"

You can also cantonate to get the filename in case of variables.

Thanx Foolio

Bill

 

[scking]

My FileSystemObject doesn't have the 'Kill' method stated above. I've never heard it associated with the FileSystemObject. You need to add a reference to the 'Microsoft Scripting Runtime' to use the object.

Dim fso As FileSystemObject
Call fso.DeleteFile("C:\Groups\MyFilename.xls&quot

The FileSystemObject is very rich with file handling functionality, including other methods such as BuildPath, CopyFile, CopyFolder, CreateTextFile, CreateFolder and about 12 others.

-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------