Thanks. Those are terrific ideas. But I found this in another search and it works great:
This eliminates the need for the kill statement altogether.![]()
Sub Auto_Open() Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:="H:\My_File(TMP).xls", _ FileFormat:=xlNormal, CreateBackup:=False Application.DisplayAlerts = True End Sub
Bookmarks