Can we find the excel sheets created dates and time.

Posted on 2007-07-25
Medium Priority
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
  • 2
LVL 24

Accepted Solution

mankowitz earned 2000 total points
ID: 19571770
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

ID: 19590272
Where and how should i run this script.
LVL 11

Author Comment

ID: 19607295
Any help...

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My previous article  (http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/A_4466-A-beginners-guide-to-installing-SCCM2007-on-Windows-2008-R2-Server.html)detailed one possible method to get SCCM 2007 installed an…
Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Suggested Courses

840 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