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

Change "Creation Date" to "last save time"


Gord Dibben MS Excel MVP

On Wed, 9 May 2007 10:50:03 -0700, Mrs. C. <Mrs.
wrote:

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

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" wrote:

Change "Creation Date" to "last save time"


Gord Dibben MS Excel MVP

On Wed, 9 May 2007 10:50:03 -0700, Mrs. C. <Mrs.
wrote:

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

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


On Wed, 9 May 2007 13:44:00 -0700, Mrs. C.
wrote:

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" wrote:

Change "Creation Date" to "last save time"


Gord Dibben MS Excel MVP

On Wed, 9 May 2007 10:50:03 -0700, Mrs. C. <Mrs.
wrote:

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