• Re: AutoOpen macro to "save as..."

    From haha pipa@21:1/5 to troub...@gmail.com on Fri Nov 5 20:56:20 2021
    On Saturday, March 29, 2014 at 7:40:16 AM UTC+7, troub...@gmail.com wrote:
    On Thursday, May 17, 2001 1:28:08 PM UTC-7, AB wrote:
    I have an AutoOpen macro that automatically saves the document
    with a specific name & in a specific location upon opening. Code is:

    Sub AutoOpen()
    '
    ' AutoOpen Macro

    ActiveDocument.SaveAs FileName:="test.doc", FileFormat:= _ wdFormatDocument, LockComments:=False, Password:="", AddToRecentFiles:= _ True, WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:= _
    False, SaveNativePictureFormat:=False, SaveFormsData:=True, _ SaveAsAOCELetter:=False
    End Sub

    Question: is there a way to stop the macro at the "save as..."
    dialog box in order for the user to choose a new name?
    Thanks in advance for any help!

    --AB
    Hi, AB. Is there a way to make this macro pause each time and wait for a unique name? I need an AutoOpen macro that immediately allows me to save a standard contract as a new document in a separate subdirectory, to avoid overwriting the original
    document.

    Thanks so much,

    David Cooper
    I also need help, please help me!
    _________________________
    https://wordcounter.tools

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)