Delete File in a folder

[Les Stout]

Hi all, i save a file to a folder using a certain name and after i have
finished with it and closed it i need to delete it. I have played with
some code but just cannot get it to work. Could somebody help me out of
my misary please !!

Les Stout

 

[Raymond Cruz]

Set fs = CreateObject("Scripting.FileSystemObject")
Set obj = fs.GetFile("your-file-name")
obj.Delete

 

[Tom Ogilvy]

If you want to use the built in VBA capabilities:

Kill "C:\MyFolder\MyFile.xls"

 

[Bob Phillips]

Kill full_filename_including_path

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Les Stout]

Thanks Bob and Tom, have a great weekend.

best regards,

Les Stout