Creation 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
 
F

Frank Kabel

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
 
M

Martin Racette

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
 
M

Martin Racette

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
 
Top