Thread: Syntax for Info or Cell function for xl. file creation date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Syntax for Info or Cell function for xl. file creation date
Hello again:

Function dates() As String
dates = " created " & ActiveWorkbook.BuiltinDocumentProperties(11)
dates = dates & " updated " & ActiveWorkbook.BuiltinDocumentProperties(12)
End Function
--
Gary's Student
gsnu200703


"driller" wrote:

i cant find it? i need to have a formula that will embed the file creation
date and modfied date in a concatenated formula sentence.
--
*****
birds of the same feather flock together..

Reply With QuoteReply With Quote