Thread: Creation Date
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Kjell Forssen
 
Posts: n/a
Default Creation Date

Hi again
Thank you for helping me.
It works as before wich means that I am getting the wrong date - its not the
templates date and not the date when the user template with the macros was
created and not todays date. It seems to me like if the worksheet has a
permanent date (20060418) wich not is changed when a new worksheet is created.
Great to hear from you again!
Kjell





"Kjell Forssen" wrote:

Hi
Why doesn´t this code work?

ActiveWorkbook.SaveAs FName
Sheets("Offert").Select
Range("D13").Select
ActiveCell.Value = ActiveWorkbook.BuiltinDocumentProperties("Creation
Date")