View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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