Deleting workbook
I'd have to do some digging to verify this, but can you
write: Workbooks("workbookname").Delete
-----Original 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
.
|