Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Creation Date
I need access to the File Creation Date in my Excel Sheet. Excel
ActiveWorkbook.BuiltinDocumentProperties gives access to a "creation date" but this date is the one under PropertiesStaticstics and does not match the date under PropertiesGeneral. The General Creation Date is the actual File Creation Date. The Statistics Creation Date is the first Worksheet Creation Date. I need the File Creation Date! Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Creation Date
The date in statistics is the creation date and the one in general is the
date the file was first saved to your own computer so frequently they wiil be different. The statement below will return the creation date. Sub creationdate() MsgBox ActiveWorkbook.BuiltinDocumentProperties.Item _ ("Creation date").Value End Sub If you want the date from the general tab (and I've never seen a date earlier than the one is statistics) then it's a vba routine you need and there are a couple here. http://j-walk.com/ss/excel/tips/tip57.htm "Felicity" wrote: I need access to the File Creation Date in my Excel Sheet. Excel ActiveWorkbook.BuiltinDocumentProperties gives access to a "creation date" but this date is the one under PropertiesStaticstics and does not match the date under PropertiesGeneral. The General Creation Date is the actual File Creation Date. The Statistics Creation Date is the first Worksheet Creation Date. I need the File Creation Date! Any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Creation Date
You might try getting the Windows file system time, rather than using the
built in file time properties. See http://www.cpearson.com/excel/FileTimes.htm -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Felicity" wrote in message ... I need access to the File Creation Date in my Excel Sheet. Excel ActiveWorkbook.BuiltinDocumentProperties gives access to a "creation date" but this date is the one under PropertiesStaticstics and does not match the date under PropertiesGeneral. The General Creation Date is the actual File Creation Date. The Statistics Creation Date is the first Worksheet Creation Date. I need the File Creation Date! Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing a particular excel worksheet into another excel file | Excel Worksheet Functions | |||
Changing date from =NOW() to Creation Date | Excel Worksheet Functions | |||
Move or copy sheet causing the creation of an htm file | Excel Discussion (Misc queries) | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) |