SaveAs defaults...

Using this code to save when the file already exists...

Logfile = "filename.xls"
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:=CurDir() & "\" & Logfile,
ConflictResolution:=xlLocalSessionChanges
Application.DisplayAlerts = True

How do you know which default (yes|no) is taken to the overwrite message?
I assume from all the posts I have seen on this topic that the "yes" default
is taken, but what if you wanted the "no" option taken?

The parm for "ConflictResolution" seems like that should handle it, but the
options shown in the help files do not cover this.

--
Regards,
John
.

Relevant Pages

  • SATA and multiboot question
    ... FWIW there are 2 SATA plugs on the MB so I assume that ... Regards, ... John O. ... Prev by Date: ...
    (comp.sys.ibm.pc.hardware.storage)
  • Allan and Douglas Re MsgBox
    ... values to flase to show a visual indication, ... Regards ... John ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: All Indians are bog cleaners
    ... Regards, ... John G ... Prev by Date: ...
    (uk.politics.misc)
  • error trapping
    ... try and avoid this if posible ... John ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Shared data in DLLs
    ... > According to the help files, if a variable is initialized with no value ... If the initialized variable has a value e.g int number=5; ... Regards, ... Prev by Date: ...
    (microsoft.public.vc.language)