Excel file properties-statistics creation date

  • Thread starter Thread starter merle
  • Start date Start date
M

merle

I have been trying to figureout how to use VB(A) to
retrieve an excel file's creation date/time. When you
activate the file properties, a creation date/time is
given in 2 places. The "GENERAL" tab and the "STATISTICS"
tab.

These are the same when a file is first created. However,
once the file has been copied, the "GENERAL" tab date/time
is changed to the current date/time. I am interested in
finding out how to read the "STATISTICS" date/time using VB
(A). The "STATISTICS" date/time is the original date/time
the file was first created.

Any suggestions or help is appreciated.

Merle
 
Merle,

Try this from the VBA Immediate window:

?ThisWorkbook.BuiltinDocumentProperties("Creation Date")

For the Last Saved Date/Time, try:

?ThisWorkbook.BuiltinDocumentProperties("Last Save Time")

John
 
Back
Top