code to delete a file

[Guest]

one of my macro generates an output file by the name of SimRes.xls in the
following path
D:\~Pradip\~My Documents\2_Personal\RSI\FINAL\simulation results\SimRes.xls
every time i run the code, excel prompts that file by that name already
exists, do i want to delete it.
is it possible to delete the workbook through some code.

thanks
pradip

 

[Guest]

Kill "<filename>"

 

[Guest]

how do i specify the path of the file.
the code i am writing is in file names RSIfinal.xls which is in the
following location:
D:\~Pradip\~My Documents\2_Personal\RSI\FINAL\RSIfinal.xls

the file i want to delete is the following:
D:\~Pradip\~My Documents\2_Personal\RSI\FINAL\simulation results\SimRes.xls

what code would i write in the file RSIfinal.xls

thanks
pradip

 

[OJ]

Look up the word Kill in help