Here is an example of what I use. It's probably not the best way, but works
for me.

Dim wbName As String
Dim Wb1 As Workbook
Set Wb1 = ActiveWorkbook
Dim Wb2 As Workbook

wbName = Wb1.Sheets("Your Sheet").Range("Your Range")

Workbooks.Add
Set Wb2 = ActiveWorkbook

'Or

'Set Wb2 = Workbooks.Open("C:\Your XLS File.xls")

Wb1.Sheets("Your Sheet").Range("Your Range").Copy
Destination:=Wb2.Sheets("Your Sheet").Range("Your Range")
Application.DisplayAlerts = False
Wb1.Close False
ActiveWorkbook.SaveAs (wbName)
Application.DisplayAlerts = True

If you use the FileSystemObject there is a FileExists method.

You can also delete  files using the FileSystemObject.

You may find  this link useful.

http://www.tek-tips.com/faqs.cfm?fid=4116

Apologies for not including it previously.

There's also a slightly easier, though older-fashioned way to delete  a file
in VB, which is to just use the KILL command, like



Kill "C:\Documents and Settings\David\My Documents\See Ya!.doc"



But then you need to do an error trap in case the file  doesn't exist, etc.



I prefer use of FileSystemObject.

Thanks to everyone who sent an answer to me. I will try all of them and
have to see what works best. At least I now have a very good idea of how to
do what is needed and to try and keep out of trouble!!

Trouble is so easy to get into and very hard to get out of. Best to avoid
it if you can and prevent it happening.

see word.mvps.org/FAQS/MacrosVBA/DeleteFiles.htm

You could also use the Win32 API - which allows one to execute powerful windows
commands in VBA. see http://abstractvb.com/code.asp?A=658