Can we find the excel sheets created dates and time.

Posted on 2007-07-25
Last Modified: 2010-05-18

Is there any way to find the excel sheets sheets created date and time.I have 20 sheets in a file.I want to know there details.

Question by:bsharath
    LVL 24

    Accepted Solution

    The following VBA statement will tell you when the workbook was created, but it won't tell you about the individual sheets:
      MsgBox ActiveWorkbook.BuiltinDocumentProperties.Item("Creation date").Value

    One way to accomplish what you are talking about is to create a macro that runs whenever a worksheet is created. Have it insert the current date into some (hidden) cell.
    LVL 11

    Author Comment

    Where and how should i run this script.
    LVL 11

    Author Comment

    Any help...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    This is a little timesaver I have been using for setting up Microsoft Small Business Server (SBS) in the simplest possible way. It may not be appropriate for every customer. However, when you get a situation where the person who owns the server is i…
    Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
    This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
    Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now