Deleting a file on C drive using VBA

[Todd Huttenstine]

I need to delete the file C:\Sheets.xls using VBA.
How do I do this?

Thank you
Todd Huttenstine

 

[Dave Peterson]

Take a look at the Kill command in Help.

I need to delete the file C:\Sheets.xls using VBA.
How do I do this?

Thank you
Todd Huttenstine

 

[Todd Huttenstine]

Below is the code I used and its closing the file, not
deleting the file.


Kill "c:\sheets.xls"

 

[Todd Huttenstine]

nevermind I got it.

-----Original Message-----
Take a look at the Kill command in Help.





--

Dave Peterson
(e-mail address removed)
.

 

[Guest]

Untested air code (needs reference to Microsoft Scripting Runtime Library [scrrun.dll]):

Dim fso as FileSystemObject
Dim f as File

Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.GetFile("C:\Sheets.xls")

f.Delete

Set f = Nothing
Set fso = Nothing

Hope this helps!

Jake
----- Todd Huttenstine wrote: -----

Below is the code I used and its closing the file, not
deleting the file.


Kill "c:\sheets.xls"

 

[Pete McCosh]

Todd,

The Kill command wont work if you have the file you want
to kill open, as I presume you must have, otherwise you
couldn't close it!

Pete

 

[onedaywhen]

Untested air code (needs reference to Microsoft Scripting Runtime Library [scrrun.dll]):

Dim fso as FileSystemObject
Dim f as File

Change these declarations to 'As Object' and the reference is not needed.

 

[Dave Peterson]

Actually, you can kill that open workbook:

This was posted by Jim Rech:

Sub testme()

With ThisWorkbook
.Saved = True
.ChangeFileAccess xlReadOnly
Kill .FullName
.Close False
End With

End Sub

(make sure you have backups!)