View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default VBA code for CreatedBy ("author") and CreatedOn

ActiveWorkbook.BuiltinDocumentProperties("Author")

See the VBA help for a list

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Mario" wrote in message ...
What will be the VBA code for Created by (i.e, Author)
and Created on. I Intend to use it in a class module to
insert that information in my excel footer. I am using
excel 2000.

Please help
Thanks