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

*** Sent via Developersdex http://www.developersdex.com ***

[Raymond Cruz]

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

"Les Stout" <[email protected]> wrote in message
news:%[email protected]...
> 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
>
> *** Sent via Developersdex http://www.developersdex.com ***

[Tom Ogilvy]

If you want to use the built in VBA capabilities:

Kill "C:\MyFolder\MyFile.xls"


--
Regards,
Tom Ogilvy

"Les Stout" <[email protected]> wrote in message
news:%[email protected]...
> 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
>
> *** Sent via Developersdex http://www.developersdex.com ***

[Bob Phillips]

Kill full_filename_including_path

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Les Stout" <[email protected]> wrote in message
news:%[email protected]...
> 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
>
> *** Sent via Developersdex http://www.developersdex.com ***

[Les Stout]

Thanks Bob and Tom, have a great weekend.

best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***