delete xls file 4

[scrappe7]

Hi I am looking for the the coding that would delete an xls file. My current macro opens some source data files then copys all the data to 1 file. i would like to then have those source files deleted. Is this possible? I knwo you can open and close xls files from excel but can you DELETE them as well?

 

[SkipVought]

Hi,
Here's a way to delete Excel file "C:\exa.xls"...

    Dim fs, f
    Set fs = CreateObject("Scripting.FileSystemObject")
    Set f = fs.GetFile("C:\exa.xls")
    f.Delete

Hope it helps Skip,
metzgsk@voughtaircraft.com

 

[DaleWatson123321]

Skip,

Thanks, I can use this.

...Dale Watson dwatson@bsi.gov.mb.ca

 

[tomschafer]

A shorter version would be using Skips example file would be

kill "C:\exa.xls"

 

[DaleWatson123321]

Pezamystik,

You've just proven... "there's ALWAYS another option",
and it appears yours is indeed preferable.

THANKS !!! ...and a STAR to you too.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca