Creation date

  • Thread starter Thread starter Martin Racette
  • Start date Start date
M

Martin Racette

Hi,

I would like a way to insert the creation date of worksheet, not the creation
date of the template.

--
Thank you in Advance

Merci a l'Avance

Martin
 
Hi
you'll need VBA for this. Find below a UDF for this task:

Public Function Get_Creation_date() As Date
Get_Creation_date =
ActiveWorkbook.BuiltinDocumentProperties("Creation Date")
End Function

Enter the following in your target cell:
=Get_Creation_date()
and format the result as date
 
I tried the code listed below, but all I get is a #NAME? in the cell

BTW I inserted the in "ThisWorkbook (Code)", I don't know if I'm correct but I
assumed that it was the correct place. Another point I'm using Excel 2003 but it
wil be use as an Excel 97 sheet

--
Thank you in Advance

Merci a l'Avance

Martin
 
Thanks,

I fix this part, but I still have a little problem, it keep giving me the date
that the template workbook was created, and not the date that the new workbook
was created

--
Thank you in Advance

Merci a l'Avance

Martin
 
Back
Top