Please Help! Creation Date from Properties

[jesterhs]

Is there a way to insert the Created and Modified dates from the file properties box into the actual excel spreadsheet?

Any help would be greatly appreciated.

Thanks!

[dominicb]

Good evening Jesterhs

The only way I can think of would involve VBA, so you'll find that this routine does the trick:

Sub CreateDate()
g = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")
Range("A1").Select
ActiveCell.Value = g
End Sub

This will put the date and time into cell A1, but how exactly it is displayed depends upon how you format that particular cell. In addition to that, you will have to run the macro to update the cell. One way to get around that would be to call the macro on opening, either by calling it auto_open or dropping it into the workbook_open event procedure.

HTH

DominicB

[jesterhs]

Thanks. I will give that a try!

[dominicb]

You're welcome.
Thanks for the feedback.

DominicB