• Macros in Excel (Office 97)

    Author
    Topic
    #379099

    Is it Possible to put a save command at the end of a Macro, so when it is finished it will auto save? If so how do you enter the code ([Ctl]+) ???

    Viewing 0 reply threads
    Author
    Replies
    • #630041

      ActiveWorkbook.Save will save the Activeworkbook, or if you want to rename the file use ActiveWorkbook.SaveAs filename

      Andrew C

    Viewing 0 reply threads
    Reply To: Macros in Excel (Office 97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: