View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jeff M Jeff M is offline
external usenet poster
 
Posts: 15
Default How can I force the file to over write the existing file

Try:

On Error Resume Next
kill sFileName
On Error GoTo 0
sbkNew.SaveAs sFileName

Cheers - Jeff

"Ed" wrote:

have the follow code which works fine unless a file of that name already
exists.
wbkNew.SaveAs sFileName

How can I force the file to over write the existing file.

Ed