Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim p As String
If Not Me.Saved Then
Me.Save
End If
p = "E:\GHOST\"
If Dir(p, vbDirectory) = "" Then MkDir p
Me.SaveAs p & Replace(Me.Name, ".xls", "") & Format(Now(), "_yyyymmdd_hhmmss") & ".xls"
Application.Quit
End Sub