Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change formatting from general to date | Excel Discussion (Misc queries) | |||
Created date in "General" tape and "Statistics" tape | Excel Discussion (Misc queries) | |||
how to convert julian date to general date | Excel Worksheet Functions | |||
CSV Date Format and General Arrrggghhh-ness | Excel Discussion (Misc queries) | |||
How to change date as general "200306" to date "06/2003" | Excel Discussion (Misc queries) |