Deleting workbook
 

if dir("R:\PROTEUSIMP.xls") < "" then
kill "R:\PROTEUSIMP.xls"
end if
ActiveWorkbook.SaveAs Filename:="R:\PROTEUSIMP.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False

--
Regards,
Tom Ogilvy

"tina" wrote in message
...
Hello
Is it possible to delete a workbook in a macro?
I would like to delete old workbook in first line of code so when the
macro uses the save as command with this name later in code it does not
produce prompt to replace
ActiveWorkbook.SaveAs Filename:="R:\PROTEUSIMP.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False
or is there away to enter true to replace
when I tried with recordmacro nothing was recorded
thanks
Tina