Date Created reported as wrong
What does the word template mean here. Template as in File=New and you
select a template or did you create the workbook by opening another workbook
and doing file SaveAs and giving it a new name.
Regards,
Tom Ogilvy
Randall Arnold wrote in message
...
Well, I figured out what is causing it, but not why.
Even though I'm trying to get the Date Created of an Excel spreadsheet,
what's actually being returned is the Creation Date of the template used
to
create it. Ack! Not good.
Any advice?
Randall
"Randall Arnold" wrote in message
...
When I examine a certain spreadsheet in Windows Explorer, it shows the
Date
Created as January 6, 2003. However, when using the following code in
Excel
2003:
MsgBox ThisWorkbook.BuiltinDocumentProperties("Creation Date")
The Date Created is reported as July 16, 2003! (on July 18, 2003).
Anyone else experience this, and know of a solution?
Randall Arnold
beta tester 237445
|