View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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