Can I use file information (title, subject,) as fields in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
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.


User Defined Functions (UDFs) are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the UDF in and close the VBE window

If you save the workbook, the UDF will be saved with it.

To remove the UDF:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To learn more about UDFs and macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top