Save As behaviour
Probably because you don't have any existing workbooks that have exactly
that name. If you eventually have such duplicate named books, you will
probably have the problem.
--
Regards,
Tom Ogilvy
"Peter" wrote in message
...
Tom Ogilvy wrote:
Private Sub cbEnd_Click()
Dim fname As String
Application.DisplayAlerts = False
fname = "Last end status"
ActiveWorkbook.SaveAs Filename:=fname,
ConflictResolution:=xlLocalSessionChanges
Application.DisplayAlerts = True
Unload Me
End Sub
Thanks Tom, that's a bit more elegant than my workaround using KILL. Any
idea why the second worked with no issues or is it an "undocumented
feature"?
Peter
|