Thread: How can I get date of file creation to XLS cell in date format?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How can I get date of file creation to XLS cell in date format?
Try this one-line UDF:

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

--
Gary''s Student - gsnu200755


"Radek Simek" wrote:

I'm using Excel Standard Edition 2003 (11.5612.8132) and have following
problem. I need to get date of file creation (e.g. from Properties - file
created) to specific excel cell (in day format) of the same file. Does any
simple way (function?) exist?
Reply With QuoteReply With Quote