created date on General Tab

[Mrs. C.]

Hi,

I used the following (provided by "Kjell Forssen" in another question.

Sub GetCreateDate()
If InStr(1, ActiveWorkbook.FullName, "\") = 0 Then
MsgBox "You must save the workbook first"
Exit Sub
End If
ActiveCell.Value = ActiveWorkbook.BuiltinDocumentProperties("Creation Date")
End Sub

It worked beautifully, but it shows the "created date" on the Statistics
tab. I need to show the "created date" on the General tab. It's to be used
in a template and I want the date that shows to be the date each time the
template is used and "saved-as".

Thanks for the help!
Regards,
Lynda

 

[Gord Dibben]

Change "Creation Date" to "last save time"


Gord Dibben MS Excel MVP

 

[Mrs. C.]

Thanks for such a quick response! This is the first time I'm using the
discussion group. I just want to make sure I understand correctly.

If I use "last save time", it will grab the Created date from the General
Tab? Not the Modified date?

I'll try it.

Thanks again,
Lynda

 

[Gord Dibben]

It will grab the date/time that you last saved the workbook.

It will not grab the "Date Created".

That date is fixed when you create the workbook and save first time.

Accessed and Modified can be different if you don't save after accessing.

Modified will update when you save.


Gord