LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change formatting from general to date JH Excel Discussion (Misc queries) 2 February 9th 07 03:21 PM
Created date in "General" tape and "Statistics" tape Winnie Excel Discussion (Misc queries) 1 January 5th 07 02:43 PM
how to convert julian date to general date arkprabha Excel Worksheet Functions 1 April 3rd 06 10:22 AM
CSV Date Format and General Arrrggghhh-ness andyiain Excel Discussion (Misc queries) 2 February 10th 06 03:44 PM
How to change date as general "200306" to date "06/2003" Delwyn Excel Discussion (Misc queries) 1 June 15th 05 03:24 AM


All times are GMT +1. The time now is 10:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"