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

Thank you
Todd Huttenstine

Take a look at the Kill command in Help.



Todd Huttenstine wrote:

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

Thank you
Todd Huttenstine

--

Dave Peterson

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


Kill "c:\sheets.xls"

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



Todd Huttenstine wrote:

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

Thank you
Todd Huttenstine

--

Dave Peterson

.

nevermind I got it.


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



Todd Huttenstine wrote:

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

Thank you
Todd Huttenstine

--

Dave Peterson

.

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"

-----Original Message-----
Take a look at the Kill command in Help.
Todd Huttenstine wrote:
I need to delete the file C:\Sheets.xls using VBA.
How do I do this?
Thank you
Todd Huttenstine
--
Dave Peterson

.

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

"Jake" wrote in message ...
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.

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!)



Pete McCosh wrote:

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

--

Dave Peterson