Delete a file using VBA

[Anonymous]

Hello everyone,

Does anybody have an example of how to delete a file (in this case a text file). I have looked at the help, and can see the object.delete and object.deletefile methods but neither have an example for me to rip-off err! I mean to draw inspiration from!

Roy Meaden.

[Anonymous]

Hi Roy,

Use the "Kill" statement.

From help ...

' Assume TESTFILE is a file containing some data.
Kill "TestFile" ' Delete file.

' In Microsoft Windows:
' Delete all *.TXT files in current directory.
Kill "*.TXT"

[Anonymous]

Delete Method


Description

Deletes a specified file or folder.

Syntax

object.Delete force

The Delete method syntax has these parts:

Part Description
object Required. Always the name of a File or Folder object.
force Optional. Boolean value that is True if files or folders with the read-only attribute set are to be deleted; False (default) if they are not.

[Anonymous]

Thanks for the reply, but call me Mr.Thickie, I do not know how to reference the file. I guess it would go something like (in pseudocode)

Dim filename as ?????

set filename = ??????

filename.delete true

set filename = nothing

Any help filling the blanks would be greatly appreciated!

Roy

[Anonymous]

dim strg as string
dim fs as variant
Set fs = CreateObject("scripting.filesystemobject")
strg = "myfile.txt"
ChDir {where myfile is}
fs.deletefile strg1, 1
I believe the current directory must be set to the file location for
this to work.

I always use something like Kill "myfile.txt"

Tom
RoyMeaden wrote:

> Thanks for the reply, but call me Mr.Thickie, I do not know how to
> reference the file. I guess it would go something like (in pseudocode)
>
>
> Dim filename as ?????
> set filename = ??????
> filename.delete true
> set filename = nothing
>
> Any help filling the blanks would be greatly appreciated!
>
>
>
> Roy

[Anonymous]

Thanks Tom ( And Gary )

Kill worked great. Another lesson learned.

Thanks

Roy