How can I include file properties in an excel spreadsheet

[Guest]

I frequently save file properties such as the title, author, company name etc
and wanted to be able to use these values in excel without having to retype
them in the spreadsheet.

I can do this in word using the insert field function in Microsoft word, do
you know if there is anything similar in excel?

 

[Guest]

You can create tiny functions (UDFs) to get you the information. For example:

Function author()
author = ActiveWorkbook.BuiltinDocumentProperties(3)
End Function

So in a worksheet

=author()

will display the author's name.