VBA Footer

  • Thread starter Thread starter kerbe
  • Start date Start date
K

kerbe

I have created a module which automatically puts the file path and
current date in the footer of any file I create. What I would like to
do it to also put in the author (creator-not who modified it or who is
viewing it) of the spreadsheet and the create date. Anyone have
script already written for this?
 
If you mean the author as it appears in the workbook properties in the File
menu use:

ActiveWorkbook.BuiltinDocumentProperties(3)

--
Jim
|I have created a module which automatically puts the file path and
| current date in the footer of any file I create. What I would like to
| do it to also put in the author (creator-not who modified it or who is
| viewing it) of the spreadsheet and the create date. Anyone have
| script already written for this?
 
ActiveWorkbook.BuiltinDocumentProperties("Creation Date")

to go along with the Author which Jim supplied


Gord Dibben MS Excel MVP
 
Back
Top