VBA Footer

[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?

 

[Jim Rech]

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?

 

[Gord Dibben]

ActiveWorkbook.BuiltinDocumentProperties("Creation Date")

to go along with the Author which Jim supplied


Gord Dibben MS Excel MVP