• File Save Date Formula

    Author
    Topic
    #475344

    Is there a formula that will let me include the date/time I saved or created the Excel file? I’m using Excel 2007.

    Thanks for your help.

    Viewing 1 reply thread
    Author
    Replies
    • #1271148

      Caroline,

      Windows already does that just look at the file in Explorer. Do you want to include it in the file name for some reason?

      May the Forces of good computing be with you!

      RG

      PowerShell & VBA Rule!
      Computer Specs

      • #1271343

        Caroline,

        Windows already does that just look at the file in Explorer. Do you want to include it in the file name for some reason?

        Thanks RG, yes I want that information in my spreadsheet. I actually wanted to put it in the footer but a cell at the top of the worksheet will suffice.

    • #1271288

      If you want it in a cell:

      Code:
      Public Function LastSaveTime() As Date
         Application.Volatile
         LastSaveTime = Application.Caller.Worksheet.Parent.BuiltinDocumentProperties("Last Save Time")
      End Function
      
    Viewing 1 reply thread
    Reply To: File Save Date Formula

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

    Your information: