View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mrs. C. Mrs. C. is offline
external usenet poster
 
Posts: 1
Default created date on General Tab

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